| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the simplest way
Change the cells number format
Format Cells Number Then select custom It has 4 sections separated by semi-colon Positive;negative;zero;text so for eg. "0.00";[RED]-"0.00";"" Positives: 2 decimal places Negatives: 2 decimal places in red Zero : is blank Although i prefer to use the dash "0.00";[RED]-"0.00";"-" The dash is less intrusive but still lets you know the cell has a value and is not blank George famdamly wrote: to have a cell that has a value of zero just be blank instead of showing the 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the simplest way to print multiple worksheets? | Charts and Charting in Excel | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
Threaded Mode
