Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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

Re: Adding decimil into a number

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.