Convert 1.1B to 1,100,000.00
If they are just formatted like that then you need to change the format to
NUMBER.
If the numbers are in Col A then you can test by
=ISNUMBER(A1)
in B1
If the result is TRUE then just change the format
If it is false then use the formula
=IF(RIGHT(A1,1)="B",(LEFT(A1,LEN(A1)-1))*1000000000,IF(RIGHT(A1,1)="M",(LEFT(A1,LEN(A1)-1))*1000000,A1))
in B1 and copy down
"SteveM" wrote:
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.
|