Does anyone know how to remove the leading ' that is added to the start of
every cell by the DTS process. The reason I am trying to do this is to make:

'=HYPERLINK("http://www.microsoft.com", "Click for report")

Loose the leading ', if I do this manually I get the desired hyperlink. How
can I automate this. I have tried left and min, both strip the ' but do not
then result in a hyperlink.