| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cell custom Number format
what custom number format can I use to be % if there is a number but General
if the is not. So 0.02 will come as 2.0% But 0 will come as nothing Thanks, Dan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format cell custom Number format
0.0%;-0.0%;0
-- David Biddulph "Dan" wrote in message ... what custom number format can I use to be % if there is a number but General if the is not. So 0.02 will come as 2.0% But 0 will come as nothing Thanks, Dan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format cell custom Number format
This'll do it...
0.0%_);[Red](0.0%);_(* ""??_);_(@_) -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dan" wrote: what custom number format can I use to be % if there is a number but General if the is not. So 0.02 will come as 2.0% But 0 will come as nothing Thanks, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I shade a cell using custom number format codes. | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Format Cell (Number Custom) | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Hybrid Mode
