in B1 try this:
=value(a1)

if you have blanks:
=if(a1="","",value(a1))

this is using a formula instead of code.

James


-----Original Message-----
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
.