Sounds like the entries are still text.
What happen with this formula =ISNUMBER(B2) where B2 is your first number?
Do you get FALSE? Try this:
Enter the number 1 in a cell; copy this cell
Select the troubled values; use Edit | Paste Special and check Multiply
This often gets text to turn to numbers (when possible, off course)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SLP" wrote in message
...
Hello. I am trying to do an =sum for 205 rows. The result is 0. I
checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are
formatted as numbers. (Also tried it with General). The cells that lead
into
those cells are not text. Any ideas on what is wrong? Thanks.