MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert to decimal


Posted by A.R. on February 26, 2001 12:45 PM

I have rows (most over 10 rows) of numbers from one Excel file and paste that data to another Excel file. My problem is that the data I copy is in whole numbers (Ex. 7,500) while the format I paste it must be in decimal format (Ex. 7.500). I tried to create a macro but that did not work properly. Any tips and ideas so I can save time instead of typing it all of this manually.

Thanks.


Posted by Dax on February 26, 2001 12:51 PM


Assuming I'm understanding your problem correctly, you could use Paste Special. E.g. type 0.001 in any blank cell, copy it, then select your range of numbers and choose Edit, Paste Special, Multiply. This will then divide all of your numbers by 1000.

Posted by Dave Hawley on February 26, 2001 5:12 PM

A.R

I addition to what Dax has said.

Try preformating your destination cells as wanted then when you paste the numbers in use Edit>PasteSpecial-Values

OzGrid Business Applications

Posted by A.R. on February 27, 2001 9:28 AM

Thank you Dax

Your method worked. Thanks.