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

[Dave O]

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

Dave O
Eschew obfuscation

[Fred Smith[_4_]]

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

[Django]

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