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

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



--

Regards,

Peo Sjoblom



"MikeC" <MikeC@discussions.microsoft.com> wrote in message
news:229987B9-00BA-408E-9FD4-BAFBE5642BCC@microsoft.com...
> 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?

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 format>style, from dropdown select style name currency
> click modify and select currency as opposed to accounting
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "MikeC" <MikeC@discussions.microsoft.com> wrote in message
> news:229987B9-00BA-408E-9FD4-BAFBE5642BCC@microsoft.com...
> > 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?
>
>
>

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" <MikeC@discussions.microsoft.com> wrote in message
news:5A407631-787B-4F22-990E-F417AF9E1091@microsoft.com...
> 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 format>style, from dropdown select style name currency
>> click modify and select currency as opposed to accounting
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "MikeC" <MikeC@discussions.microsoft.com> wrote in message
>> news:229987B9-00BA-408E-9FD4-BAFBE5642BCC@microsoft.com...
>> > 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?
>>
>>
>>