Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding null sums
I have a spreadsheet that calculates sums across a varying
number of columns. The problem is that when there is no data in the cells, I get a display of ########. This doesn't look too pretty on paper, and I'd like to get rid of unused Sums, or at least hide the pound signs. Any suggestions on how to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding null sums
"Chris M." wrote in message ... I have a spreadsheet that calculates sums across a varying number of columns. The problem is that when there is no data in the cells, I get a display of ########. This doesn't look too pretty on paper, and I'd like to get rid of unused Sums, or at least hide the pound signs. Any suggestions on how to do this? Search Excel help for # and you will see that : A ##### error value occurs when the cell contains a number, date, or time that is wider than the cell or when the cell contains a date and/or time formula that produces a negative result. If the cells are indeed blank as you say, the result should be 0. Bob L. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding null sums
You are correct. My formulas were wrong, and now they
display a "-". Any help in removing these would also be appreciated. Thanks in advance. -----Original Message----- "Chris M." wrote in message ... I have a spreadsheet that calculates sums across a varying number of columns. The problem is that when there is no data in the cells, I get a display of ########. This doesn't look too pretty on paper, and I'd like to get rid of unused Sums, or at least hide the pound signs. Any suggestions on how to do this? Search Excel help for # and you will see that : A ##### error value occurs when the cell contains a number, date, or time that is wider than the cell or when the cell contains a date and/or time formula that produces a negative result. If the cells are indeed blank as you say, the result should be 0. Bob L. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding null sums
Chirs,
Create a custom format by right clicking on the cell and picking format cells. Then in number tab pick custom and roll your own there (see Excel help for more about custom formats). For example you could use this as the custom format: #,##0_);[Red]General;"" (It sets the format for positive numbers;negative numbers; zero. The "" is a zero length string meaning show that when the result is zero. I think that is what you want) Bob L. "Chris M." wrote in message ... You are correct. My formulas were wrong, and now they display a "-". Any help in removing these would also be appreciated. Thanks in advance. -----Original Message----- "Chris M." wrote in message ... I have a spreadsheet that calculates sums across a varying number of columns. The problem is that when there is no data in the cells, I get a display of ########. This doesn't look too pretty on paper, and I'd like to get rid of unused Sums, or at least hide the pound signs. Any suggestions on how to do this? Search Excel help for # and you will see that : A ##### error value occurs when the cell contains a number, date, or time that is wider than the cell or when the cell contains a date and/or time formula that produces a negative result. If the cells are indeed blank as you say, the result should be 0. Bob L. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Global hiding null rows | Excel Discussion (Misc queries) |