MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re: inserting decimal for cents


Posted by Kevin on December 17, 2000 4:55 PM

Could someone suggest how I might be able to have
a price of $20.20 to be represented from a table
value of 20200.

Thank you


Posted by CPod on December 18, 2000 6:12 AM

Just divide by 1000 and format for currency.


Could someone suggest how I might be able to have