Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
1687 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.