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
 
Back
Top