Simple Question

[Dave]

I have a cell with a value of 1601
What process can I use to convert this number to 16.01?
The column of data may vary in the number of digits, but
I will always want the decimal place to be 2 digits from
right to left.

Thank you for your help.

 

[Arvi Laanemets]

Hi

=OldValue/100

 

[Don Guillett]

Here is a formula
=LEFT(A1,2)&"."&RIGHT(A1,LEN(A1)-2)

 

[Don Guillett]

Or a macro
Sub dodots()
For Each c In Range("a1:a22")
c.Value = Left(c, 2) & "." & Right(c, Len(c) - 2)
Next
End Sub

 

[Guest]

Perfect example me trying too hard to develop a solution.
Thank you Arvi.

 

[Gord Dibben]

Dave

Enter 100 in an empty cell.

Copy it.

Select your range of numbers and Paste Special>Divide>OK>Esc

Clear the cell with 100.

Gord Dibben Excel MVP