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.
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.
Last edited by excel_learner; 10-16-2011 at 10:50 AM.
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
Try this format
0",000,000.00"
Regards,
Edit:Note: This only works if the number is a 1-3 digit whole number.
EF
Last edited by Excel Fox; 10-16-2011 at 02:24 PM. Reason: Note
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
As per you note, you can modify your Custom Format to handle numbers greater than 3 digits also by doing it this way...Originally Posted by Excel Fox
#,##0",000,000.00"
Posting Permissions
Reply With Quote
Bookmarks