I used hyperlink function before and I just tried it again. It works fine for me. I use Excel 2003.
See if the following link gives you some inspiration.
http://www.mrexcel.com/archive/Formulas/19517.html
A line from the above link:
"The value in column 2 is exactly a link reference (not a true hyperlink -- rather a spec for a hyperlink)."
Epinn
"Frank B Denman" wrote in message ...
Forgot to mention this is Excel 2k3 SP2
Frank Denman
Denman Systems
[Please delete the "x" from my email address]