Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting 0 to a Dash without using Currency
Hello All,
I am trying to convert a zero (0) to a dash. I know I can do this as a currency format but when I do that it does not center. I am trying to do a custom format that would allow me to convert the number 0 to a dash (-) and allow me to move it to the center or left hand side of the cell. Any suggestions would be greatly appreciated! Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting 0 to a Dash without using Currency
_($ #,##0_);_($ (#,##0);_($ "-"_);_(@_)
this allows you to align as you describe. -- Regards, Tom Ogilvy "cardan" wrote: Hello All, I am trying to convert a zero (0) to a dash. I know I can do this as a currency format but when I do that it does not center. I am trying to do a custom format that would allow me to convert the number 0 to a dash (-) and allow me to move it to the center or left hand side of the cell. Any suggestions would be greatly appreciated! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERTING CURRENCY TO WORDS | Excel Discussion (Misc queries) | |||
Converting more than one currency | Excel Worksheet Functions | |||
Converting currency to a description | Excel Discussion (Misc queries) | |||
Converting Currency | Excel Worksheet Functions | |||
Converting currency | Excel Programming |