Jim wonders how he can get Excel to automatically display numbers using 'k' for thousands and 'm' for millions. As an example, if a cell contains the value $470,000 he would like it displayed as $470k; if it contains the value $1,107,432 he would like it displayed as $1.1m. One obvious method is to create a formula that will display the information as desired.
The following formula will take into account the magnitude of the number in cell B2 and then provide a formatted text string appropriate to that magnitude: =IF(B2 1000000$#.0,'m';1000$#,'k';$#,##0 This format will display both millions and thousands using the desired notation. If the number is below a thousand then it will be displayed without any special notation. As appropriate, values are rounded to one decimal place.
Custom Number Format For Displaying MAC Addresses Oct 18, 2005. I'm trying to create an Excel sheet to display MAC addresses in the following format - 00:00:00:00:00:00. Custom Number Format (hundred-thousands, Millions) May 22, 2009. I have a giant sheet that culminates in a graph. It is for various regions.