When I typed =ISTEXT(A1), I got "true."

So, what's the best way to change all of my numbers so that they're
interpretted as numbers and not text?

"Bernard Liengme" wrote:

Show us the actual formula and tell us what is the cell the formulas
references
Suppose you have =SUM(A1:A10) - what is the result of =ISTEXT(A1) ? Is it
TRUE or FALSE?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott" wrote in message
...
Hello,

I have a SUM( ) formula that is not working. The number format is "General
(not text)." I have also manually recalculated but I'm still getting a
zero
for the total. Any ideas?

Thanks,
Scott