Dollar sign alignment - Accounting vs Currency style

[MikeC]

My preference of formatting cells with dollar signs is to align the dollar
sign adjacent to the leftmost number rather than aligning it to the left side
of the cell. Excel’s Currency formatting feature does this whereas the
Accounting format aligns the $ to the left side of the cell.

I would like to use the toolbar to easily format a cell using the Currency
formatting style so the dollar sign is aligned as I desire rather than the
longer process of using the Excel menu <FORMAT> <CELL> etc.

The dollar sign icon on the Formatting toolbar uses the Accounting
formatting style rather than the Currency style. I cannot figure a way to
get an icon on the toolbar to format a cell using the Currency formatting.

Is there a way to get Currency formatting onto the toolbar?

 

[Peo Sjoblom]

Sure, click format>style, from dropdown select style name currency
click modify and select currency as opposed to accounting

 

[MikeC]

Thank you. This worked in the workbook where I made the style change.
However, it does not function in other workbooks unless I make this style
change to every workbook individually. (BTW - I closed Excel and restarted
after making the style change.)

Is there a way to modify the this style in a template or some other way so
the style modification applies to all workbooks?

Thanks.

 

[Peo Sjoblom]

You could create a custom button on your menu, record a macro into your
personal.xls where you change to currency format, attach that macro to the
custom button