W3Ask






HOME  >  SOFTWARE  >  EXCEL

How to replace thousands with a k in Excel




We have a table with numbers which are expressed in thousands of units, which makes the table difficult to read. We therefore want to reduce the data in the cells by replacing the thousands with the letter K, the millions with the letter M and thus make it easier to read the next time you open the Excel file.

For the thousands, we will use the following formula after having right clicked on the cell, and having chosen "custom":

100k
#.##0,k

3.7k
#.0,k

For the millions:

1.2m
#.0,,"m"













Related posts:


How to get the maximum value in Excel
https://w3ask.com/maximum-value-in-excel/
We have two column, A and B, with towns in A and numbers in B. We would like to determine the maximum value in B, the city with the biggest ...
How to convert cm to feet and inches in Excel
https://w3ask.com/convert-cm-feet-inches-excel/
It might be useful to display size, for example human heights in inches and feet in order to satisfy american internet users while they are ...
Sum by week and day with Excel
https://w3ask.com/sum-week-day-excel/
You need to calculate the sum for the day, and for the week on an Excel sheet. How to proceed to get the results to these calculation automatically ...
How to add lines with a VBA code in Excel
https://w3ask.com/how-add-lines-vba-code-excel/
If you want to automatically add line in your Excel sheet, you can use a VBA code. The following example will add lines after the N column in ...
Choice of a list with a condition in Excel
https://w3ask.com/choice-list-condition-excel/
There are two sheets, in which there is two colums : – from A1 to A3 with dates (example : 01/01/2016), – from B1 to B3 with titles ...