User Tools

Site Tools


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:-

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