Help

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

Topic Labels: Formulas
Solved
Jump to Solution
790 2
cancel
Showing results for 
Search instead for 
Did you mean: 
J_W1
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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} ) )

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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} ) )
J_W1
6 - Interface Innovator
6 - Interface Innovator

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

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