Format cells to display truncated values?
 

I would like to display numbers rounded or truncated by 1000 - eg $254,123
would be displayed as $254K. I do not want to change the underlying value,
and I do not want to add an additional column with a calculated value

Use a custom number format of
$0,K

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Mike" wrote in message
...
I would like to display numbers rounded or truncated by 1000 -
eg $254,123
would be displayed as $254K. I do not want to change the
underlying value,
and I do not want to add an additional column with a calculated
value

Perfect, thanks. I also went further, and ended up with $#,#00,K -- which
adds the comma for millions. Thanks very much.

"Chip Pearson" wrote:

Use a custom number format of
$0,K

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Mike" wrote in message
...
I would like to display numbers rounded or truncated by 1000 -
eg $254,123
would be displayed as $254K. I do not want to change the
underlying value,
and I do not want to add an additional column with a calculated
value