ExcelBanter - automatic comas for numbers greater than 999

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - automatic comas for numbers greater than 999 (https://www.excelbanter.com/new-users-excel/104386-automatic-comas-numbers-greater-than-999-a.html)

jonj34

automatic comas for numbers greater than 999

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

Mark

automatic comas for numbers greater than 999

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..

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