Formatting numbers like 1.7k to 1700, 1M to 1000000 etc

Anyone can help me make a formula to write out the below numbers in a Single Line text field (A) that are styled like below, to full digits in a Formula Field (B)?

Field A
1
10
100
1k
10k
100k
1.1k
10.1k
100.1k
1M
1.1M
Etc.

So far I’ve come up to this formula. But it’s very lacking.
SUBSTITUTE( Views, REGEX_EXTRACT({Views}, "\.\d+k"), "00")

It outputs 100 when its 1.7k and doesn’t work at all for entries like 1 to 999 and 1M upwards.

I rather wish that this formula didn’t work. But you should try it anyway. Please reply with your thoughts after you have tried it.

VALUE( LOWER( {Views} ) )
1 Like

It works like a charm! Awesome approach that’s way outside my own box.

:pray: thanks for all your help in the community.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.