Transform or Replace Numbers in Column

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.

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

Transform file.
TransformOrReplaceNumbers.transform (3.1 KB)


Thank you for the quick response!