Try:

Sub ConvertText()
Columns("A:A").TextToColumns Destination:=Range("A1")
End Sub

In om,
snax500 typed:
In Excel2000, what is the best way to code a macro that will convert a
column of text to values. For example, I have the following in column
A:

'100
'1000
'20

I want this to be converted to values like this:

100
1000
20

Thanks