display to thousand

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Use a custom format of: #,

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