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