Convert 1.1B to 1,100,000.00
Try this:
=IF(ISTEXT(A1),10^(LOOKUP(RIGHT(A1),{"B","K","M"}, {9,3,6}))*LEFT(A1,LEN(A1)-1),A1)
"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.
|