Format numbers

[Misty R]

I have a column of numbers: 15, 22, 11 etc
I need to be able to have Excel go back and put a decimal point after the first number in each cell. There are about 600 entries and I don't want to have to physically change it to 1.5, 2.2 1.1 etc.
Any suggestion?

 

[Ziggy1]

I could give you a VB function, but I don't think it is nescessary, you can simply add a column beside with a formula....

Multiply cell X 0.1

then copy it down, then copy the Column...do Paste special> Values onto the original and delete the temp column.

 

[Misty R]

You always hope that when you ask a question - it has a difficult answer. Not an easy one that is staring you right in the face. Can't believe I missed this. Thanks!

 

[Ziggy1]

not a problem, happens to all of us

 

[shades]

Or even simpler with no need for an extra column, put 0.1 into a blank cell, then select that cell and Copy, then select the entire set of numbers, right-click and choose Paste Special, and select Values and click on the Multiply button, and click OK.
________
Maryjane