Inserting decimal place in Excel

I have imported a document into Excel which has several columns of pricing. However, when the original document was created, they neglected to put in the decimal place. Is there an easy way to install the decimal place?
ie: 1000 should be 10.00

 

I was afraid of that. Actually, I have found out that the document was created in Excel, in this manner....oh well.

 

Set up a forumla to do the conversion then after the forumla column is populated with the correct values and formatted as numeric with 2 decimal places, copy it and paste special into another column as shown in the pictures.

Note that there is a way to force a cell with a number via forumla to just the number but I forget what it is so am giving the extra copy/paste step.

 

Great, thanks, I'll give that a try. I will let you know how I make out.

 

Assume that all entries are in column A, starting A1.

In Cell B1 enter the formula +A1/100. The result will give you what you want.

Format B1 to have 2 decimal places if it isn't already formatted that way.

Copy the result all the way down column B with the drag handles or ctrl+c, ctrl+v or right click copy, highlight the column as far as necessary and right click paste.

Delete column A.

 

jdover - problem is, when you have a formula that refers to A1 to give a value in B1 and then delete A1, the forumua isn't happy and B1 goes to zero or #ref depending on exactly how you cleared A1. That's why the extra step to copy the forumua result and paste-special as a value in a C1.

 

Oops, forgot that. Paste values is the same - I have put buttons for all these kinds of steps on my toolbar. If you want, you can actually paste over your formula instead of making a third column.

 

I have found that I do not have the option "Formula's and Numbers" in my paste special function. Am I missing something? I have tried this numerous times and I keep only correctly formatting the 1st cell....

 

Success! I got it figured out. Newt, your formula worked fine. In the beginning, I forgot to make a 2nd copy of the column. Once I got in the correct colomn and the formula worked, all I had to do was fill down and all numbers were corrected. Thanks for your help!