Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cells as text not numbers???
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieve text from merged cells | Excel Worksheet Functions | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How to Replace numbers and text with numbers only? | Excel Worksheet Functions |