How to convert 1k to 1000 and 1m to 1000000 in Excel
I have text data containing numbers with abbreviations for thousands (k) and millions (m). I want to convert these to numeric values. For example 1.2k to 1200 and 1.8m to 1800000. How can I do that?
You can use search to return the relative position in a string of the suffix. Then raise ten to that number time 3.
You can use this Formula to convert abbreviated data into Numbers:
Formula in Cell
C80& fill it down.
1,000,000,000which is multiplied by
Adjust cell references in the Formula as needed.
Our Awesome Tools
- Check your IP Address precisely
- Online JSON Formatter with Syntax Highlight
- Online CSS Minifier Compressor