custom number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I'd try:

_($* #,###.#,_);_($* (#,###.#,);_($* "-"??_);_(@_)
or maybe
_($* #,###.0,_);_($* (#,###.0#,);_($* "-"??_);_(@_)
 
Oops. That second one should have been:

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

(.# was changed to .0 and I screwed it up)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting from a group 6
How do I extract the decimal places from a number in excel? 3
Trim varying decimals from column of numbers 9
Forming my own numeric representations 7
Parse text & numbers & format 1
Formatting a number 2
Formula to add two spaces into a number stored as text 3
Convert number to text as displayed 3

Back
Top