Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Result of SUM is #
I have a spreadsheet where the result of using autosum is displayed as a
single #. Some of the cells being summed contain a 'x' but even if I chnage all these to numerics I still end up with #. I've tried reformatting the cells. This autosum is of 26 contiguos cells in a row. Funny thing is autosumming the same data down a column is OK. Any ideas folks?! |
#2
|
|||
|
|||
Have you tried widening the column. If the number is too big, it will show
up as #'s. -- Sincerely, Michael Colvin "TonyJag via OfficeKB.com" wrote: I have a spreadsheet where the result of using autosum is displayed as a single #. Some of the cells being summed contain a 'x' but even if I chnage all these to numerics I still end up with #. I've tried reformatting the cells. This autosum is of 26 contiguos cells in a row. Funny thing is autosumming the same data down a column is OK. Any ideas folks?! |
#3
|
|||
|
|||
Michael wrote:
Have you tried widening the column. If the number is too big, it will show up as #'s. I have a spreadsheet where the result of using autosum is displayed as a single #. [quoted text clipped - 3 lines] row. Funny thing is autosumming the same data down a column is OK. Any ideas folks?! Michael, yes, tried that but even if I expand the column to a screen wide it just keeps looking at me! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200510/1 |
#4
|
|||
|
|||
TonyJag wrote:
Have you tried widening the column. If the number is too big, it will show up as #'s. [quoted text clipped - 3 lines] row. Funny thing is autosumming the same data down a column is OK. Any ideas folks?! Michael, yes, tried that but even if I expand the column to a screen wide it just keeps looking at me! HOLD THE FRONT PAGE! Have just sussed it. # is showing the cell IS too small for the number. The person seems to have changed the orientation of the cells to vertical. Therefore if you increase the height of the cell the answer appears with the numbers one above the other! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to .. | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel |