automatic comas for numbers greater than 999

J

jonj34

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

Mark

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Need help on macro to do ranking 2
tickets and numbering them. 0
Use TODAY() function as the criteria in a SUMIF formula 1
change decimal dots per coma (in word) 4
Code to insert a coma 26
Help with formula! 2
Count Word in long string 2

Top