Z
zander
how do you format a cell so that when you enter 1254 the number is displayed
as 1,254,000
as 1,254,000
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas
You don't. You enter 1254000 and format it as #,##0
Bob Umlas
Excel MVP
Bob Umlas
Excel MVP
D
David McRitchie
What do you want for a value?
Do you want the value to remain 1254 but display as 1,254,000
Do you want the value to remain 1254 but display as 1,254,000
J
JonOfAllTrades
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.
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.
Z
zander
#,##0",000" this is the format that I needed thanks !