display to thousand

S

sh

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
 
F

FARAZ QURESHI

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
 
F

FARAZ QURESHI

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

Fred Smith

Use a custom format of: #,

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