| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) | |||
| How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
Hybrid Mode
