Excel 2003 - How to display 761000 in a cell as 761

L

Lacey Tree

In Excel 2003 I want to display 761000 in the cell as 761. The column header
is "$ in thousands", so I don't want to use the last three zeros in each
cell. How do I format the cell to display 761,000 as 761? I already have a
round function in this cell to round the number 760507 to 761000.

Thanks,
 
D

Dave Peterson

Try a custom format of:
0,
(zero comma)

Lacey said:
In Excel 2003 I want to display 761000 in the cell as 761. The column header
is "$ in thousands", so I don't want to use the last three zeros in each
cell. How do I format the cell to display 761,000 as 761? I already have a
round function in this cell to round the number 760507 to 761000.

Thanks,
Click to expand...
 
Top