| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
In Excel ### appears in the cell, not the sum. Why?
I am using the sum formula to sum across rows. The formula works, but for
one set of calculations the actual sum does not appear in the destination cell, only a series of ####. How can I get the actual sum to appear? This is only occuring for 1 set of the calculations. All others work |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
In Excel ### appears in the cell, not the sum. Why?
Trying increasing the column width (position your cursor up in the column
header -- on the right edge and double click... or click and drag. Or with the column selected, go to Format -- Column Width and increase the number until your data displays completely. Kathryn Groves MOUS - Office 2000 "BYT" wrote in message ... I am using the sum formula to sum across rows. The formula works, but for one set of calculations the actual sum does not appear in the destination cell, only a series of ####. How can I get the actual sum to appear? This is only occuring for 1 set of the calculations. All others work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HTML in cell appears as text | Excel Discussion (Misc queries) | |||
| cell selection appears to be locked | Excel Discussion (Misc queries) | |||
| Checking if a number appears within a cell | Excel Discussion (Misc queries) | |||
| The number I type in a cell, e.g. 500, appears at 0.5 - why? | Excel Discussion (Misc queries) | |||
| Applied color to excel cell but no color appears | Excel Discussion (Misc queries) | |||
Hybrid Mode
