What Am I Doing Wrong?

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Very simple formula - just trying to add up columns of
numbers - formula I'm using is =SUM(B8:G8); the result I
get is always 0. Also, when I attempt to add enter a
number, sometimes, it enters the number as a decimal.
Thanks for any help.
 
Sounds like your data is stored as text. Copy an empty cell, select your data
and do Edit / Paste Special / Add. As for entering the data and it turning to
decimals, check you don't have Tools / Options / Edit Tab / Fixed decimal places
checked.
 
Thanks - that helped - not sure how I'm storing my data as
text. Also, now I'm trying to add the totals of the
columns for a grand total with no luck.
 
Hi Wendy

if this hasn't been sorted yet, i'ld be happy to look at your xls file -
please email me direct.

Cheers
JulieD
 
Back
Top