Hello,

Can you post your macro?

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"ExcelNovice" wrote in message
...
I have recorded a Macro which will edit a cell from text to numeric. The
problem I have is that the Macro will only do one cell at a time. I am
working on a huge database and the file I am working with has an
apostrophe
at the beginning and ending of the values I need to convert.

I need a quick response as I am under a tight deadline.