Prev: Re-installed Office 2003 and the licensing agreement pops up each
Next: bullet formatting in a spreadsheet
From: bwong on 1 Mar 2010 20:12
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


From: Jacob Skaria on 2 Mar 2010 01:07
Select the cell range. Right click>Format CElls>Custom format to

_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

--
Jacob


"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
>
>
> .
>
From: bwong on 2 Mar 2010 05:22
Thanks for the reply. But is there a way to change the default of the comma
button/icon.

Cheers
Ben

"Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message
news:F058CEFC-5E14-487B-B7DD-F2772E07E72E(a)microsoft.com...
> Select the cell range. Right click>Format CElls>Custom format to
>
> _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
>
> --
> Jacob
>
>
> "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
>>
>>
>> .
>>


From: Dave Peterson on 2 Mar 2010 08:17
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
From: pmartglass on 2 Mar 2010 11:04
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
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Re-installed Office 2003 and the licensing agreement pops up each
Next: bullet formatting in a spreadsheet