View Single Post
  #3   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

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