custom number format
 

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

custom number format
 

I'd try:

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



ACotton wrote:

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

--

Dave Peterson

custom number format
 

Oops. That second one should have been:

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

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

Dave Peterson wrote:

I'd try:

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

ACotton wrote:

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

--

Dave Peterson

--

Dave Peterson

custom number format
 

Thank you so much. It worked great.
Alejandra

"Dave Peterson" wrote:

Oops. That second one should have been:

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

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

Dave Peterson wrote:

I'd try:

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

ACotton wrote:

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

--

Dave Peterson

--

Dave Peterson