Format cells to display truncated values?

M

Mike

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
 
M

Mike

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