Formating question
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
|