Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
default currency format
Is there a way to change the default accounting format in Excel 2007 so that
a zero shows when the number is zero. I know how to set a custom format. I just want that to be an option in the custom list all the time. I want zero values to show as $ 0.00 with the fixed $ located on the left side of the cell. -- Judy L |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
Default display format for "currency" data type | Excel Discussion (Misc queries) | |||
Default to zero currency value | Excel Worksheet Functions | |||
Default settings for currency | Setting up and Configuration of Excel | |||
Default Currency | Excel Discussion (Misc queries) |