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.