| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom number format - Accounting
I have a custom format: [500]_(* #,##0,_);[<-500]_(* (#,###,);_(*
"-"_);_(@_). This does the job fine for values between 0 and 500 which shows "-", but, if the number is between -1 and -500 on the sheet, the result is "- -". And all I want is the "-" like you get when you select Accounting number format. I am trying to figure out how/why this is happening, any ideas? Solutions? Thanks, Jon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number format | Excel Discussion (Misc queries) | |||
| Format Number to Text | Excel Worksheet Functions | |||
| Format Number (custom) | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| Custom Number Format for Weight | Excel Discussion (Misc queries) | |||
Linear Mode
