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

I have large data where i have numbers like 1.6 (million) i want convert them as 1,600,000 and so..

i have attached the file for easy reference. if it can be done by formating cell it will be very good.

kindly assist.

Try this format

0",000,000.00"

Regards,

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

Why do you want to just change the format? Why not the value itself? Like use =(B3+C3)*10^6 for million =(B3+C3)*10^9 for billion etc.

Thanks

Quote:

---

Originally Posted by Excel Fox

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"