| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency & Accounting Format Mixture
We have a 2003 spreadsheet where we would like "$" to remain on the left side
of the cell, but if the cell value is "0.00" - we would like that displayed, instead of just a dash. Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency & Accounting Format Mixture
Custom format the cells to . Isnt that the default currency format..
$#,##0.00 If this post helps click Yes --------------- Jacob Skaria "pmsimp" wrote: We have a 2003 spreadsheet where we would like "$" to remain on the left side of the cell, but if the cell value is "0.00" - we would like that displayed, instead of just a dash. Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency & Accounting Format Mixture
Yes this can be done. Right click and format cells, in the number tab, go to
custom and use the following: _($* #,##0.00_) pmsimp wrote: We have a 2003 spreadsheet where we would like "$" to remain on the left side of the cell, but if the cell value is "0.00" - we would like that displayed, instead of just a dash. Can this be done? Thanks! -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between Currency and Accounting number format. | Excel Discussion (Misc queries) | |||
| Accounting Format Parentheses | Setting up and Configuration of Excel | |||
| Currency vs. Accounting Format | Excel Worksheet Functions | |||
| Dollar sign alignment - Accounting vs Currency style | Excel Discussion (Misc queries) | |||
| Data Validation - mixture of options | Excel Discussion (Misc queries) | |||
Hybrid Mode
