Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I sum up figures the answer is zero, what will I do?
Please help me on my excel problem.
When I sum up all my figures the answer that comes out is 0; and when I copy the sum formula of other cell the answer is the same as the figures from the origin cell. Is this something to do with cell formating? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I sum up figures the answer is zero, what will I do?
May be the cells in the sum range are formatted as text..Try the below
workaround Copy a blank cell. Keeping the copy select the sum rangeRight clickPaste Specialselect AddHit OK to convert these cells to 'General' format. Now try the sum formula on these cells If this post helps click Yes --------------- Jacob Skaria "May" wrote: Please help me on my excel problem. When I sum up all my figures the answer that comes out is 0; and when I copy the sum formula of other cell the answer is the same as the figures from the origin cell. Is this something to do with cell formating? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
How to sum of two max figures out of five and four figures | Excel Worksheet Functions | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) |