Converting 13.6B (B stands for bilion) into 13600000000

[Vjosaa]

Hello.

Im very new at using exel and i dont have much knowledge.Im doing a project.
So for example in A1 its written 13.6B (B stands for bilion) so i need a formula which will convert 13.6B into 13600000000 in the B1.
I failed to figure it out myself so could someone please help me.

Thank you for taking your time to read my post.

 

[shg]

Cross-posted at Converting 13.6B (B stands for bilion) into 13600000000