If you change your formula to:

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

But I'd just use two columns (A and B) and then hide column A when I didn't want
to see it anymore.

Paul1 wrote:

Can it go in the same place? It will put the same number into two places
this way. Thanks for all the help thus far, btw.

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

--

Dave Peterson