Substitute "$ 0.00" for "$ - " in Excel 2013 Accounting number format

metsmaniac

New Member
Joined
Jan 29, 2010
Messages
45
How do I substitute "$ 0.00" for "$ - " in Excel 2013 Accounting number format?
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

adam087

Well-known Member
Joined
Jun 7, 2010
Messages
1,356
I got it using this number format (entered in the 'Custom' group).
_-[$$-409]* #,##0.00_ ;_-[$$-409]* -#,##0.00 ;_-[$$-409]* "-"??_ ;_-@_
Hope that helps
/AJ
 

metsmaniac

New Member
Joined
Jan 29, 2010
Messages
45
Thanks. That worked. I had to modify that a little because the "0.00" wasn't lining up with the other numbers. It was centered even though I didn't have format set for centering.

So it looks like this:
_($* #,##0.00_);_($* (#,##0.00);_($* "0.00"_);_(@_)

Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top