A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Comma Style Question



 
 
Thread Tools Display Modes
  #1  
Old July 6th 09, 11:19 AM posted to microsoft.public.excel.newusers
Steveal
external usenet poster
 
Posts: 2
Default Comma Style Question

When I format a cell using the "Comma Style" toolbar button, I get 2
decimal places shown along with the comma separated thousands.

Is it possible to change the 2 decimal places? Whenever I use the
button, I always want my numbers displayed as comma separated
thousands with NO decimal places.
Ads
  #2  
Old July 6th 09, 12:39 PM posted to microsoft.public.excel.newusers
Bernard Liengme[_3_]
external usenet poster
 
Posts: 1,104
Default Comma Style Question

In pre-Excel 2007: Open the Format; locate Style; in the dropdown box select
Comma; now use Modify and decrease decimals to zero.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Steveal" > wrote in message
...
> When I format a cell using the "Comma Style" toolbar button, I get 2
> decimal places shown along with the comma separated thousands.
>
> Is it possible to change the 2 decimal places? Whenever I use the
> button, I always want my numbers displayed as comma separated
> thousands with NO decimal places.



  #3  
Old July 6th 09, 12:43 PM posted to microsoft.public.excel.newusers
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Comma Style Question

You can change the Comma style:

Format|Style (in xl2003 menus)
or
Home tab|Style group|Cell Styles icon (on the xl2007 ribbon)

Change the comma style to what you want.

These styles live in workbooks. It's not an excel setting. So every existing
file needs to have thing changed (if you want).

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

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

Steveal wrote:
>
> When I format a cell using the "Comma Style" toolbar button, I get 2
> decimal places shown along with the comma separated thousands.
>
> Is it possible to change the 2 decimal places? Whenever I use the
> button, I always want my numbers displayed as comma separated
> thousands with NO decimal places.


--

Dave Peterson
  #4  
Old July 6th 09, 05:56 PM posted to microsoft.public.excel.newusers
Steveal
external usenet poster
 
Posts: 2
Default Comma Style Question

Thank you both.

Steve




On Jul 6, 12:43*pm, Dave Peterson > wrote:
> You can change the Comma style:
>
> Format|Style (in xl2003 menus)
> or
> Home tab|Style group|Cell Styles icon (on the xl2007 ribbon)
>
> Change the comma style to what you want.
>
> These styles live in workbooks. *It's not an excel setting. *So every existing
> file needs to have thing changed (if you want).
>
> If you want this style for new workbooks, you can create a new workbook, save it
> as book.xlt (a template file) in the XLStart folder.
>
> A new workbook will be created based on this workbook when you click on the New
> Icon on the standard toolbar.
>
> Steveal wrote:
>
> > When I format a cell using the "Comma Style" toolbar button, I get 2
> > decimal places shown along with the comma separated thousands.

>
> > Is it possible to change the 2 decimal places? Whenever I use the
> > button, I always want my numbers displayed as comma separated
> > thousands with NO decimal places.

>
> --
>
> Dave Peterson


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change default value of comma style Khoshravan Excel Discussion (Misc queries) 5 February 4th 09 11:54 PM
About comma style in MS Excel Amrit Excel Discussion (Misc queries) 1 March 18th 08 11:57 AM
comma in indian style Sattu Excel Discussion (Misc queries) 1 June 6th 06 12:54 PM
Applying Indian comma style NAVEEN Excel Discussion (Misc queries) 1 February 22nd 06 09:59 AM
Currency, Percent and Comma Style buttons Leslie Coover Excel Worksheet Functions 1 January 9th 06 02:02 AM


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


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