Dollar sign alignment - Accounting vs Currency style
 

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. Excels 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?

Dollar sign alignment - Accounting vs Currency style
 

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



--

Regards,

Peo Sjoblom



"MikeC" wrote in message
...
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?

Dollar sign alignment - Accounting vs Currency style
 

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

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



--

Regards,

Peo Sjoblom



"MikeC" wrote in message
...
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?

Dollar sign alignment - Accounting vs Currency style
 

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


--

Regards,

Peo Sjoblom


"MikeC" wrote in message
...
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" wrote:

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



--

Regards,

Peo Sjoblom



"MikeC" wrote in message
...
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?