The Comma button/icon
 

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

The Comma button/icon
 

Select the cell range. Right clickFormat CEllsCustom 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


.

The Comma button/icon
 

Thanks for the reply. But is there a way to change the default of the comma
button/icon.

Cheers
Ben

"Jacob Skaria" wrote in message
...
Select the cell range. Right clickFormat CEllsCustom 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


.

The Comma button/icon
 

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

The Comma button/icon
 

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
.

The Comma button/icon
 

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

The Comma button/icon
 

Thanks for the replies pmart and dave

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