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