MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Foramtting numbers


Posted by Olga on October 10, 2001 6:56 AM

Easy way to format numbers in millions (ie 30,500,000 to 30.5)


Posted by IML on October 10, 2001 7:00 AM

You could apply the custom format
#.0,,

good luck

Posted by Olga on October 10, 2001 8:05 AM


Thank you. It worked!