excel_notes
This is an old revision of the document!
concatenate with a delimiter
This will combine B3, C3 and D3 with '_' as the delimiter.
=B3&"_"&C3&"_"&D3 <code> ==== format dollars ==== To put the dollar sign on the left and right justify the number, use the custom format <code> _($* #,##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.1610643423.txt.gz · Last modified: 2021/01/14 16:57 by raju