Display Data in Thousands in Excel 2007
 

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.
--
Django

Display Data in Thousands in Excel 2007
 

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

Dave O
Eschew obfuscation

Display Data in Thousands in Excel 2007
 

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

$0,

Regards,
Fred.

"Django" wrote in message
...
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.
--
Django

Display Data in Thousands in Excel 2007
 

Thanks Fred.
--
Django


"Fred Smith" wrote:

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

$0,

Regards,
Fred.

"Django" wrote in message
...
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.
--
Django