Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Error, Hidden Formatting
I'm trying to sum a column of numbers with =Sum(A2:A5). Excel acts like no
numbers are present. I tried changing cell formating, from general to text to number with no effect. I can view the numbers but formulas don't seem to recognize them. any suggestions to fix this would be great. thanks Lee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Error, Hidden Formatting
changing the format of the cells will not change the data format. If your
problem is truly that the numbers are stored as text, you have two options: 1. Highlight all of the cells, and click the "!" button that will be visible to the right of your top most cell, then click convert to number. 2. type 1 into an empty cell, copy that cell, then highlight (A2:A5) and paste special. Select multiply in the paste special form and press OK. BN "Lee" wrote: I'm trying to sum a column of numbers with =Sum(A2:A5). Excel acts like no numbers are present. I tried changing cell formating, from general to text to number with no effect. I can view the numbers but formulas don't seem to recognize them. any suggestions to fix this would be great. thanks Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error in hidden module | Excel Discussion (Misc queries) | |||
Compile error in hidden module | Excel Discussion (Misc queries) | |||
Compile Error in Hidden Module: | Setting up and Configuration of Excel | |||
Compile error in hidden module | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |