Prev: Re-installed Office 2003 and the licensing agreement pops up each
Next: bullet formatting in a spreadsheet
From: Dave Peterson on 2 Mar 2010 13:05
Nope.

I like the comma button the way it is.

pmartglass wrote:
>
> Have you tried writing a macro and saving it to a button on a custom toolbar ?
>
> "Dave Peterson" wrote:
>
> > Clicking the comma icon applies the Comma style.
> >
> > So if you change the comma style
> > In xl2003 menus:
> > format|style|select Comma|click modify
> >
> > Be aware that styles live in workbooks, so this change will only change the
> > style in the active workbook.
> >
> > But you could create a book.xlt template workbook in your XLStart folder that
> > has this modified style.
> >
> > xl2003 and below will use that template workbook when you create a new workbook
> > by clicking on the new icon on the standard toolbar.
> >
> >
> >
> > bwong wrote:
> > >
> > > When using the comma button/icon, it also adds 2 decimal places.
> > >
> > > Is there a way to customise this button/icon... make it default not to
> > > include the decimal places?
> > >
> > > Thanks
> > > Ben
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
From: bwong on 3 Mar 2010 18:54
Thanks for the replies pmart and dave

"pmartglass" <pmartglass(a)discussions.microsoft.com> wrote in message
news:79E72544-85AE-4901-AF03-C6AD07BDDCAB(a)microsoft.com...
> Have you tried writing a macro and saving it to a button on a custom
> toolbar ?
>
> "Dave Peterson" wrote:
>
>> Clicking the comma icon applies the Comma style.
>>
>> So if you change the comma style
>> In xl2003 menus:
>> format|style|select Comma|click modify
>>
>> Be aware that styles live in workbooks, so this change will only change
>> the
>> style in the active workbook.
>>
>> But you could create a book.xlt template workbook in your XLStart folder
>> that
>> has this modified style.
>>
>> xl2003 and below will use that template workbook when you create a new
>> workbook
>> by clicking on the new icon on the standard toolbar.
>>
>>
>>
>> bwong wrote:
>> >
>> > When using the comma button/icon, it also adds 2 decimal places.
>> >
>> > Is there a way to customise this button/icon... make it default not to
>> > include the decimal places?
>> >
>> > Thanks
>> > Ben
>>
>> --
>>
>> Dave Peterson
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Re-installed Office 2003 and the licensing agreement pops up each
Next: bullet formatting in a spreadsheet