| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In SUM cells the # sign keeps showing instead of total
AYE! my head...
i'm sure it is simple, but i cannot get the SUM cells to show the currency amount. instead, the cells keep showing ####### after i enter the formula. can anyone advise me in how to stop this from happening? what's more annoying is that one SUM cell IS working properly. what have i done? thank you! frustrated student |
|
#2
|
|||
|
|||
|
Widen the cell size
Regards, Peo Sjoblom "fyremunki" wrote: AYE! my head... i'm sure it is simple, but i cannot get the SUM cells to show the currency amount. instead, the cells keep showing ####### after i enter the formula. can anyone advise me in how to stop this from happening? what's more annoying is that one SUM cell IS working properly. what have i done? thank you! frustrated student |
|
#3
|
|||
|
|||
|
Your column is probably too narrow to display the numbers.
If your formula is in Column C, go up to the letter C that names the column. Directly to the right of it, before Column D, is a Line. Move your mouse pointer over that line and Double-Click. Alternatively, click on the cell with the formula. Then, go to Format | Column | Width, and set a bigger value than the one that is there already. tj "fyremunki" wrote: AYE! my head... i'm sure it is simple, but i cannot get the SUM cells to show the currency amount. instead, the cells keep showing ####### after i enter the formula. can anyone advise me in how to stop this from happening? what's more annoying is that one SUM cell IS working properly. what have i done? thank you! frustrated student |
|
#4
|
|||
|
|||
|
thank you thank you! now i feel quite intelligent! :)
"tjtjjtjt" wrote: Your column is probably too narrow to display the numbers. If your formula is in Column C, go up to the letter C that names the column. Directly to the right of it, before Column D, is a Line. Move your mouse pointer over that line and Double-Click. Alternatively, click on the cell with the formula. Then, go to Format | Column | Width, and set a bigger value than the one that is there already. tj "fyremunki" wrote: AYE! my head... i'm sure it is simple, but i cannot get the SUM cells to show the currency amount. instead, the cells keep showing ####### after i enter the formula. can anyone advise me in how to stop this from happening? what's more annoying is that one SUM cell IS working properly. what have i done? thank you! frustrated student |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
| Averaging only cells with data | Excel Discussion (Misc queries) | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Linear Mode
