All,

Is it possible to create a style where a number which is actually in
millions of $s appear as thousands of dollars.

e.g. if input is in millions and lets say I enter 100 and I want to see the
output in thousands (without changing the input physically) cell should show
100,000.

Thanks much,

RK

This Custom Format should work for you...

$#,##0",000"

--
Rick (MVP - Excel)


"rk0909" wrote in message
...
All,

Is it possible to create a style where a number which is actually in
millions of $s appear as thousands of dollars.

e.g. if input is in millions and lets say I enter 100 and I want to see
the
output in thousands (without changing the input physically) cell should
show
100,000.

Thanks much,

RK

Awesome.
Thanks much.

"Rick Rothstein" wrote:

This Custom Format should work for you...

$#,##0",000"

--
Rick (MVP - Excel)


"rk0909" wrote in message
...
All,

Is it possible to create a style where a number which is actually in
millions of $s appear as thousands of dollars.

e.g. if input is in millions and lets say I enter 100 and I want to see
the
output in thousands (without changing the input physically) cell should
show
100,000.

Thanks much,

RK