excel_notes
This is an old revision of the document!
format dollars
To put the dollar sign on the left and right justify the number, use the custom format
_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
Ref:-
- https://www.extendoffice.com/documents/excel/3679-excel-align-dollar-sign-left.html - has screenshots; more verbose; messy layout with ads in between content;
Afterwards- Find a better reference and link to it.
- The above link has ""-"", but I get the same result with “-”. Find out if there is a difference?
To only show the dollars (but not cents)
_($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_)
tags | dollar sign left justified
excel_notes.1603837388.txt.gz · Last modified: 2020/10/27 22:23 by raju