removing ' from imported database

[yogi]

I exported a table form access to excel, however all fields are precede
with a '.
that is '8845 shows up in cell and I want to remove the ' so that '884
becomes 8845.
I also want to remove fro the text field...
'mytext s/b mytex

 

[Tom Ogilvy]

for each cell in Range("A1:B10")
cell.Formula = cell.value
Next

 

[yogi]

Thanks...worked great