View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lacey Tree Lacey Tree is offline
external usenet poster
 
Posts: 2
Default Excel 2003 - How to display 761000 in a cell as 761

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,