View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
bwong bwong is offline
external usenet poster
 
Posts: 7
Default 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
.