Format Cell
Is there a way when a formula is 0 that it will leave the cell empty instead
of having the 0? I have a bar chart with a lot of information/values and most of the time there is no value (0).....but the charts data labels all have the 0's and it looks really overwhelming. If there is another way to do this, the information would be greatly appreciated. Thanks |
Format Cell
Pl. note that Excel see a cells format as having four Sections. These are,
from left to right Positive numbers, Negative Numbers, Zero Values and Text values. Each of these Sections are separated by a semi colon (;). To achieve what you want, format the cells as Custom and choose something like #,##0_);[Red](#,##0); this will show negative nos in RED and within () and zeros as blanks. "ossa" wrote: Is there a way when a formula is 0 that it will leave the cell empty instead of having the 0? I have a bar chart with a lot of information/values and most of the time there is no value (0).....but the charts data labels all have the 0's and it looks really overwhelming. If there is another way to do this, the information would be greatly appreciated. Thanks |
Format Cell
Hi sheeloo,
Thanks very much....worked like a charm. ossa Pl. note that Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text values. Each of these Sections are separated by a semi colon (;). To achieve what you want, format the cells as Custom and choose something like #,##0_);[Red](#,##0); this will show negative nos in RED and within () and zeros as blanks. "ossa" wrote: Is there a way when a formula is 0 that it will leave the cell empty instead of having the 0? I have a bar chart with a lot of information/values and most of the time there is no value (0).....but the charts data labels all have the 0's and it looks really overwhelming. If there is another way to do this, the information would be greatly appreciated. Thanks |
All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com