| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom number format thousands and zeros as "-"
I am currently using
#,###, to format my numbers in thousands, but I also need zeros to show as a dash "-" Thanks in advance for your help!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom number format thousands and zeros as "-"
See your other post.
Regards, Fred "jchick0909" wrote in message ... I am currently using #,###, to format my numbers in thousands, but I also need zeros to show as a dash "-" Thanks in advance for your help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
| In Excel 2007, can you add "custom" formats to number format dropd | Setting up and Configuration of Excel | |||
| Custom Format font for "xx" to yellow | Excel Discussion (Misc queries) | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
Linear Mode
