computing sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i try to autosum a column of numbers, what im getting is the formula in
the cell and not the sum. anyone know why this is happening? thanks in
advance
 
I suspect the cell where you are putting your AutoSum is formatted as Text

Regards

Trevor
 
The cell was formatted as text before the formula was entered.
Format the cell as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| when i try to autosum a column of numbers, what im getting is the formula in
| the cell and not the sum. anyone know why this is happening? thanks in
| advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
add all contiguous numbers-column-row 2
SUM: Display automatic 4
Excel autosum problem in Excel 1
AutoSum 12
easy one - multipule formulas in one cell 5
Invoke AutoSum From VBA? 4
autosum refusal to sum highlighted range 4

Back
Top