Only if A1 is empty, it will display what's in A1, if A1 is empty at times
you can use


=IF(A1="","",HYPERLINK("http://www.site.com/page.html?query=" & A1,A1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Paul1" wrote in
message ...

The cell is showing 0 instead of the numbers.


--
Paul1
------------------------------------------------------------------------
Paul1's Profile:
http://www.excelforum.com/member.php...o&userid=34428
View this thread: http://www.excelforum.com/showthread...hreadid=541945