display to thousand
 

How to display a number 122,789 become 122?
I want all number display up to thousand.
For example, 456 instead of 456,223.
Thanks

display to thousand
 

1. Type 1,000 in another cell.

2. Copy (Ctrl+C)

3. Select No.s;

4. Paste Especial (Alt+E and then S)

5. Select Divide in Operations section;

6. Hit Enter

"sh" wrote:

How to display a number 122,789 become 122?
I want all number display up to thousand.
For example, 456 instead of 456,223.
Thanks

display to thousand
 

You can also use, if you don't want to roundup, for a cell like A1=
=Rounddown(a1,0)/1000

"FARAZ QURESHI" wrote:

1. Type 1,000 in another cell.

2. Copy (Ctrl+C)

3. Select No.s;

4. Paste Especial (Alt+E and then S)

5. Select Divide in Operations section;

6. Hit Enter

"sh" wrote:

How to display a number 122,789 become 122?
I want all number display up to thousand.
For example, 456 instead of 456,223.
Thanks

display to thousand
 

Use a custom format of: #,

If your data can be in the millions, and you want to have a comma separator,
use: #,###,
--
Regards,
Fred


"sh" wrote in message
...
How to display a number 122,789 become 122?
I want all number display up to thousand.
For example, 456 instead of 456,223.
Thanks