Hi
how are you inserting this formula?
Also check that this cell is nOT formated as 'Text'

--
Regards
Frank Kabel
Frankfurt, Germany


Sujith Kumar wrote:
OBJECTIVE
Trying to build an excel sheet with Shipments for the day from the
database. I am trying to include UPS tracking number as a HyperLink
to the
UPS website.
I build the link and fill the colum using HYPERLINK function of excel

THE PROBLEM
Eg: This is a sample link i am trying to write to the colum from the
database


=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z15
16306601513843","Track
Shipment")

What happens is when the data is loaded, Excel prefix a single quote
(') to
the begining of the expression, hence the function doesnt work and
the link
is not active
This how it shows up in excel


'=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1
516306601513843","Track
Shipment")

I notice that excel does add sigle quote to all the character fields
coming
from the database..
QUESTION
1) How can I suppress this single quote?
2) If it cannot be suppressed, how can i remove this after the the
data is
loaded? Can i use a macro? ( i dont have much experience in this
area). If
yes, how?
3) Or is there any alternate approach to get to the objective

Any help would be greatly appreciated.
(Sujith
ChestNut Ridge, NY)