Convert string CCY Amount (in millions) to number

[Sohdaw]

Hi, 

How do i convert a string of CNY Amount (in millions) to number? 

eg. CNY 200M -> 200000000 (can ignore the ccy) 

[Qiu]

@Sohdaw 
This weekly challenge should help.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-235-Spell-It-Out-For-Me-Part-2/td-p/6409...

[Raj]

You can use find and replace tool

to replace "M" with "000000" or use formula tool to achieve this.