Inserting a decimal

[Sfinally]

Hopefully this is an easy one. I have a column of numbers that are 2-3 digits long. I need to format this column so that it inserts a decimal after the first digit on the right all the way through. So this:

105
90
70
130
50

Should look like this:

10.5
9.0
7.0
13.0
5.0

Is there an easy solution for this?

 

[Jonmo1]

Do you want to permanently change the numbers, or just show them that way and keep the original values?

 

[VoG]

Type 10 in a spare cell and copy it.

Select your data, Edit > Paste Special, tick Divide and click OK.

 

[Sfinally]

Permanently change is fine. These are actually codes for shoe sizes that need to be expressed as actual measurements. So the code 105 is really 10.5, or 10 1/2.

 

[Jonmo1]

What Peter Said...

 

[Sfinally]

How do you mean? Copy the 10 into the field where the size code is?

 

[Jonmo1]

1. Type 10 into any blank available cell.
2. Copy that cell
3. Highlight the range of numbers you want to change
4. Right Click - Paste Special
5. Select Values
6. Select Devide
7. Click OK

 

[Sfinally]

Ahhhh. Thank you.