Cell Formatting: Left Aligned Dollar Signs
626565Mar 19 2013 — edited Mar 20 2013Hi All,
I am trying to get a specific formatting in Financial Reporting. We need the $ (dollar signs) to be left aligned to the cell and the number right aligned.
Thus:
|$___9,000 |
|____1,000 |
Instead of
|___$9,000 |
|____1,000 |
Where _ are spaces (just imagine for a second). Is there a special character for Tab that I can put in the Format Cells box?
http://www.jwmays.com/US-Docs/OO-Calc_Cell_Formatting_Analysis.pdf
Above is exactly what we are doing in Excel, but sadly I can't replicate in FR.
Thoughts?