Convert 1.1B to 1,100,000.00
Do your cells contain text values (a number with a letter next to it) or do
they just contain a number with the letter being added by Cell Formatting?
--
Rick (MVP - Excel)
"SteveM" wrote in message
...
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.
|