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

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