Hi

Thank you Frank and Bob for your help with the code below
to convert figures such as 1.6M and 0.25M into proper
numbers.

When ever i run the code below i get the
error 'Application defined or object defined error'

Does any know why this is happening?

TIA

Sub convert()

For x = 2 To Cells(Rows.Count, "L").End(xlUp).Row
Cells(i, "L").Value = Left(Cells(i, "L").Value, Len
(Cells(i, "L").Value) - 1) * 1000000
Next x

End Sub