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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search function 6
Impossible? Condensed search results 8
Excel Excel count rows and add equal rows when matched 0
Displaying zeros in cells 2
XY Scatter Problem - strange! 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I set an average to not count blank cells as zeros? 5
Excel Stop Excel from displaying rounded values 4

Back
Top