
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 01:28 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 03:52 PM
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} ) )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 13, 2022 03:52 PM
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} ) )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2022 11:21 AM
It works like a charm! Awesome approach that’s way outside my own box.
:pray: thanks for all your help in the community.
