Convert 1.1B to 1,100,000.00
How do I format cell to convert 1.1B to 1,100,000.00 I have large
list with revenue shown in #.##B and #.##M. Need to convert Billion
and Million to standard numbers.
One way is to use
=IF(ISBLANK(A1),"",
IF(RIGHT(A1)="M",1000000*LEFT(A1,LEN(A1)-1),
IF(RIGHT(A1)="B",1000000000*LEFT(A1,LEN(A1)-1),
A1)))
and format it as a number.
|