Custom Number Format

[adrienne0914]

I would like to create a custom number format where millions are displayed as thousands. I know the formula for that is #,##0,;-#,##0, My problem is that I also need to add an accounting offset dollar sign.

So I need $ 1,000,000 displays as $ 1,000 with the dollar sign in the same position no matter how long the number is. We've been creating custom number formats for each length, but would be great to have one formula. Is this possible?

 

[lrobbo314]

Does this do what you're looking for?

$ #.00,;-$ #.00,

 

[adrienne0914]

Does this do what you're looking for?

$ #.00,;-$ #.00,

Not exactly. The problem is that the dollar sign is in different locations depending on how long the number is:
[TABLE="width: 186"]
<tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]$ 1996.49[/TD]
[TD="align: right"]$ 1648.02[/TD]
[/TR]
[TR]
[TD="align: right"]$ 1867.83[/TD]
[TD="align: right"]$ 840.31[/TD]
[/TR]
</tbody>[/TABLE]

I need the dollar signs to line up.

 

[lrobbo314]

How about this?

_($* #,##0.00,_);_($* (#,##0.00,);_($* "-"??_);_(@_)

 

[adrienne0914]

How about this?

_($* #,##0.00,_);_($* (#,##0.00,);_($* "-"??_);_(@_)

OMG! It worked like a charm. Thank you so much!!

 

[lrobbo314]

───────────────────░█▓▓▓█░▇▆▅▄▃▂
──────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
─────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
──────────░░░───░█▓▓▓▓▓▓█░▇▆▅▄▃▂ ...
─────────░███░──░█▓▓▓▓▓█░▇▆▅▄▃▂
───────░██░░░██░█▓▓▓▓▓█░▇▆▅▄▃▂
──────░█░░█░░░░██▓▓▓▓▓█░▇▆▅▄▃▂
────░██░░█░░░░░░█▓▓▓▓█░▇▆▅▄▃▂
───░█░░░█░░░░░░░██▓▓▓█░▇▆▅▄▃▂
──░█░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░█░░░█░░░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░█░░░░██░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░░█░░░░░██░░░█▓▓▓█░▇▆▅▄▃▂
─░█░█░░░█░░░░░░███▓▓▓▓█░▇▆▅▄▃▂
░█░░░█░░░██░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░█░░░░█████▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░░█░░░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░█░░░░██░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
─░█░█░░░░░████▓▓▓▓██░▇▆▅▄▃▂
─░█░░█░░░░░░░█▓▓██▓█░▇▆▅▄▃▂
──░█░░██░░░██▓▓█▓▓▓█░▇▆▅▄▃▂
───░██░░███▓▓██▓█▓▓█░▇▆▅▄▃▂
────░██▓▓▓███▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓▓▓▓▓▓█░▇▆▅▄▃▂