custom cell number

[Guest]

how do you format a cell so that when you enter 1254 the number is displayed
as 1,254,000

 

[Bob Umlas]

You don't. You enter 1254000 and format it as #,##0
Bob Umlas
Excel MVP

 

[David McRitchie]

What do you want for a value?
Do you want the value to remain 1254 but display as 1,254,000

 

[Guest]

As the two previous posts point out, that is a little odd. To do exactly
what you're asking, set the cell format to:
#,##0",000"
That will format the number with commas and then add the literal text
",000". If there is a chance that you'll have zero values, you may want this
format:
#,##0",000";-#,##0",000";0
Another option, which would probably make more sense to Mr's Umlas and
McRitchie, would be
#,##0K;-#,##0K;0
Note that with any of these formats, decimal values will not be displayed.
A literal value of 1.2 will be displayed as "1,000" or "1K". Though a trifle
brusque, Bob is probably right, you should use the real numbers and avoid
using formatting to save typing.

 

[Guest]

#,##0",000" this is the format that I needed thanks !