Cells as text not numbers???

[tkaplan]

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.

[Debra Dalgleish]

Excel is seeing the numbers as text. There are some techniques here that
you can use to convert the text to numbers, so they can be summed:

http://www.contextures.com/xlDataEntry03.html


tkaplan wrote:
> 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.
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html