custom number format

A

ACotton

I need the following number to look as follows:
Is: $ 1,075,245
Want: $ 1,075.2
Not all of the numbers are millions so I want the $ to line up to the left
and decimal to line up too.
Thanks in advance for any help.
Alejandra
 
D

Dave Peterson

I'd try:

_($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_)
or maybe
_($* #,###.0,_);_($* (#,###.0#,);_($* "-"??_);_(@_)
 
D

Dave Peterson

Oops. That second one should have been:

_($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_)
or maybe
_($* #,###.0,_);_($* (#,###.0,);_($* "-"??_);_(@_)

(.# was changed to .0 and I screwed it up)
 
A

ACotton

Thank you so much. It worked great.
Alejandra

Dave Peterson said:
Oops. That second one should have been:

_($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_)
or maybe
_($* #,###.0,_);_($* (#,###.0,);_($* "-"??_);_(@_)

(.# was changed to .0 and I screwed it up)
Click to expand...
 
Top