Transform or Replace Numbers in Column

Question
1

I have a column of numbers where some of them are 1.92M as an example so I need to multiply those cells where the “M” shows up by replacing the “M” with *1000000. Can you tell me how to do this?

Thanks in advance.

2

Here, how you do it (I took the liberty to add K for thousand and B for billion)

image
image460×627 54.1 KB

Transform file.
TransformOrReplaceNumbers.transform (3.1 KB)

2 Likes
3

Thank you for the quick response!