Be aware that if the "numbers" you are trying to sum are actually text,
then SUM will ignore them and get zero for the answer.

If that is the case, copy an empty cell, select all the cells that
contain text numbers and Edit|Paste Special|Add. (Reformatting changes
the display, but not the value of cells, and so will not convert from
text to numbers.)

Jerry

Jason Morin wrote:

It sounds like the accounting format where any number
that equals zero is formatted as "-". Or maybe a custom
format. What do you see under Format Cells Number Tab?

HTH
Jason
Atlanta, GA


-----Original Message-----
When I put in a simple formula(=Sum(a3:f3) ) and hit

enter, the formula

goes in fine. Then, when I try copying the formula, it

works fine, but the

numbers don't show up, only a dash like this - ?? I

checked the cells and

the formula is entered correctly in each but numbers it

should total don't

show up?

Thank you for any help anyone might have for me, denise:)