Format cells to display truncated values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncate a data entry cell 3
Why is Excel rounding when I truncate? 1
Excel Stop Excel from displaying rounded values 4
Problems truncating a column 3
Find truncated cells 1
Displaying 5000 3
Custom Number Format for text 8
TRIM OR TRUNCATE FUNCTION FOR 1000+ RECORDS 2

Back
Top