Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default How to change default value of comma style

When I click comma style icon for thousands separator, it always adds to
digit after decimal point. How can I change the default value to add zero
digit after decimal point.
12345 = 12,345.00 but I want 12,345
--
R. Khoshravan
Please click "Yes" if it is helpful.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to change default value of comma style

In xl2003 menus:
Format|Style
Choose Currency from the dropdown
Click Modify
change the number format to what you want.

Be aware that styles are workbook settings--not application settings. You'll
have to do this for each existing workbook that you need.

If you want this style for new workbooks, you can create a new workbook, save it
as book.xlt (a template file) in to the XLStart folder.

A new workbook will be created based on this workbook when you click on the New
Icon on the standard toolbar.




Khoshravan wrote:

When I click comma style icon for thousands separator, it always adds to
digit after decimal point. How can I change the default value to add zero
digit after decimal point.
12345 = 12,345.00 but I want 12,345
--
R. Khoshravan
Please click "Yes" if it is helpful.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default How to change default value of comma style

I have currency and currency[0]. Is the second one redundant. Can I delete it?
I did as you mentioned but nothing change. 2 zeros after decimal digits keep
coming.
BTW is comma style only defined for currency?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Dave Peterson" wrote:

In xl2003 menus:
Format|Style
Choose Currency from the dropdown
Click Modify
change the number format to what you want.

Be aware that styles are workbook settings--not application settings. You'll
have to do this for each existing workbook that you need.

If you want this style for new workbooks, you can create a new workbook, save it
as book.xlt (a template file) in to the XLStart folder.

A new workbook will be created based on this workbook when you click on the New
Icon on the standard toolbar.




Khoshravan wrote:

When I click comma style icon for thousands separator, it always adds to
digit after decimal point. How can I change the default value to add zero
digit after decimal point.
12345 = 12,345.00 but I want 12,345
--
R. Khoshravan
Please click "Yes" if it is helpful.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to change default value of comma style

Did you have any cells that were using the currency style?

Are you sure you applied the changes to the style when you were leaving the
style dialog?

And try putting:

1234.56
in both A1 and A2
Apply the Currency style to A1 and Currency[0] to A2.

You'll see the difference.

You can use comma style on any cell you want. It adds commas and displays 2
decimals. It doesn't have to be currency/money related.





Khoshravan wrote:

I have currency and currency[0]. Is the second one redundant. Can I delete it?
I did as you mentioned but nothing change. 2 zeros after decimal digits keep
coming.
BTW is comma style only defined for currency?
--
R. Khoshravan
Please click "Yes" if it is helpful.

"Dave Peterson" wrote:

In xl2003 menus:
Format|Style
Choose Currency from the dropdown
Click Modify
change the number format to what you want.

Be aware that styles are workbook settings--not application settings. You'll
have to do this for each existing workbook that you need.

If you want this style for new workbooks, you can create a new workbook, save it
as book.xlt (a template file) in to the XLStart folder.

A new workbook will be created based on this workbook when you click on the New
Icon on the standard toolbar.




Khoshravan wrote:

When I click comma style icon for thousands separator, it always adds to
digit after decimal point. How can I change the default value to add zero
digit after decimal point.
12345 = 12,345.00 but I want 12,345
--
R. Khoshravan
Please click "Yes" if it is helpful.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to change default value of comma style

I think Dave meant Comma, not Currency. Currency is invoked by clicking on
the $, Comma by clicking on the comma.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to change default value of comma style

I may have misunderstood the OP's question (it happens way to often with me!),
but I thought the OP really wanted to know an answer to this:

BTW is comma style only defined for currency?

slew0302 wrote:

I think Dave meant Comma, not Currency. Currency is invoked by clicking on
the $, Comma by clicking on the comma.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change default style (esp. font) for all comments? TheSilb Setting up and Configuration of Excel 1 July 20th 08 09:52 PM
Change the default Currency style Budgie Boy Setting up and Configuration of Excel 1 July 11th 06 07:52 AM
Change default border style? kyot58 Excel Discussion (Misc queries) 0 February 27th 06 07:00 PM
? change default line style from solid to dotted Skip Excel Discussion (Misc queries) 0 January 10th 06 02:10 PM
How can I change the default 'comma' format. Eg paranthesis inste. Duncan Excel Discussion (Misc queries) 1 December 4th 04 01:51 AM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"