MrExcel.com - Your One Stop for Excel Tips & Solutions

Adding decimil into a number

Posted by m_V_m on October 30, 2000 10:50 AM

I have a data base of about 5000 part numbers including price. The price is listed as 1200(which is $12.00) How can I insert a decimil two spaces over? When I go to FORMAT CELL>CURRENCY>DECINIL PLACES =2, it gives a value of 1200.00

Please help

Posted by Celia on October 30, 2000 3:22 PM


Enter .01 in an empty cell then Copy, select the cells containing the prices and PasteSpecial>Multiply.
Celia