Format Cell To Convert Display Number As Billion / Million / Thousand

[Rick Rothstein]

Try this format

0",000,000.00"

Regards,

Edit:Note: This only works if the number is a 1-3 digit whole number.

As per you note, you can modify your Custom Format to handle numbers greater than 3 digits also by doing it this way...

#,##0",000,000.00"