Display Data in Thousands in Excel 2007

D

Django

Appreciate it if anyone could tell me how to make Excel 2007 display $
1,000,000 as $1000 on a spreadsheet only, as well as the whole document.
Thanks for any assistance that you can provide.
 
D

Dave O

In the cells in question, create a custom format and use these
parameters:
_(* #,##0.0,,_);_(* (#,##0.0,,);_(* "-"??_);_(@_)

Dave O
Eschew obfuscation
 
F

Fred Smith

To have $1000 displayed when 1,000,000 is in a cell, use a custom format of:

$0,

Regards,
Fred.
 

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

How to copy a whole Excel spreadsheet page in 2007 vs 2003? 2
Newly opened spreadsheet doesn't display in Excel 2007 2
Likned Sheets 3
Rounding to thousands in excel 5
excel 2000 over 2007 7
Pivot Tables - Difference From 1
Opening excel 2010 spreadsheet from Access 4
Excel 2007 doesn't display worksheet 1

Top