Display Data in Thousands in Excel 2007

  • Thread starter Thread starter Django
  • Start date Start date
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.
 
In the cells in question, create a custom format and use these
parameters:
_(* #,##0.0,,_);_(* (#,##0.0,,);_(* "-"??_);_(@_)

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

$0,

Regards,
Fred.
 
Back
Top