Forum Discussion
How can I define 36B als 36 Billion?
Hi Guys, I wrote the numbers in my sheet as "36 M" instead of 36.000.000 and "36 B" instead of 36 billion. How can excel recognize this as numbers? Thanks in advance
thanks sergei. But if I substitute M by 000000, "3,4 M" are 3400000 which is one 0 to much? SergeiBaklan
Sorry, didn't think about decimals. As variant
=LEFT(A1, FIND(" ",A1) - 1 )*LOOKUP( RIGHT(A1), {"B","M"}, {1e9,1e6} )