automatic comas for numbers greater than 999

's Computer Specifications

I want exel to automaticly add comas for numbers greater than 999. How do I
accomplish this?

's Computer Specifications

jonj34 wrote:
> I want exel to automaticly add comas for numbers greater than 999. How do I
> accomplish this?

FORMATCELLS...NUMBER..Make sure that the 1,000's seperator checkbox is
selected..

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
determining the greater of three or more numbers	Darryl	Microsoft Excel Misc	1	27th Jul 2009 01:30 PM
How do I count just the numbers in a cell, no spaces or comas?	bonair	Microsoft Excel Worksheet Functions	2	13th Apr 2009 07:43 PM
formula of two numbers if greater than 500	=?Utf-8?B?ZGVi?=	Microsoft Excel Misc	3	31st Mar 2007 11:56 PM
the greater of 2 numbers	=?Utf-8?B?S2FyZW4=?=	Microsoft Excel New Users	4	16th Feb 2006 07:35 PM
Re: factorial of numbers greater than 170	Imran Koradia	Microsoft Dot NET Framework	0	7th Sep 2004 09:51 PM