Excel 2003 - How to display 761000 in a cell as 761
Thanks Dave! I don't understand why or how this worked, but it did.
"Dave Peterson" wrote:
Try a custom format of:
0,
(zero comma)
Lacey Tree wrote:
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,
--
Dave Peterson
|