I have a file with a bunch of numbers on it and when I sum them up it
returns 0. If i double click in each of the cells then the sum works.

There are a few thousand cells so i can't doubleclick in each. How can
I change them all at the same time?

I tried formatting them all as a number and that didnt work. There is
no ' before it either.

thanks in advance.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=387638