I am creating a shipment report in Excel and want to create a clickable
hyperlink to United Parcel Service's tracking information page on their web
site. The tracking number is stored in a SQL Server table. I build the link
with the tracking number as a parameter in the URL. I am trying to use the
=HYPERLINK function to create the link in the Excel cell. I can get the text
into the cell properly with the data pump task, but Excel adds a single quote
mark at the beginning oif the string and does not recognize the hyperlink
function. If I manually remove the single leading quote mark and press
ENTER, the clickable link appears.

Any ideas how I can get Excel to recognize the inserted text as a function?
Or is there some VB script I could use in DTS to make this happen?