| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide zeros
how do I hide zero results when I'm using this formula: =LEFT(AL8,1)
I have tried conditional formatting and custom numbering but ca't get it to work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide zeros
=if(left(al8,1)="0","",left(al8,1))
"ralpha" wrote: how do I hide zero results when I'm using this formula: =LEFT(AL8,1) I have tried conditional formatting and custom numbering but ca't get it to work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide zeros
A tiny trick! if the formula is in cell B9, then use conditional formatting:
FormulaIs =B9="0" and make the font color match the background color. We need the double-quotes because LEFT() returns Text rather than a number. -- Gary''s Student - gsnu201001 "ralpha" wrote: how do I hide zero results when I'm using this formula: =LEFT(AL8,1) I have tried conditional formatting and custom numbering but ca't get it to work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide zeros on pivot table | Excel Worksheet Functions | |||
| how do I hide zeros in a graphic? | Charts and Charting in Excel | |||
| hide zeros & negatives for date formulas | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| is there a way to hide zeros in a line graph | Charts and Charting in Excel | |||
Hybrid Mode
