Combining a hyperlink with cell data. ex. go.com/test.asp?(a1)

[zboyles]

I have a list of numbers, the numbers need to be run through a singl
web site address as an agrument, or whatever.

For example the range of cells A1:A50 contain the numbers 1000-1050.
I need to run them through a single web address such a
www.example.com/number.cgi?(the sell number here)

I would need each row to contain this formula with its own column
number in it.
So the final hyperlink, if A1 was clicked, would display:
www.example.com/number.cgi?1000

I know this has to be simple. I have done it with xml and asp i jus
need to know how to do it with excel.

it might look something like:
=hyperlink(http://www.example.com/number.cgi?(A1))
but that doesn't work.

Please HELP!!

 

[keepITcool]

if you want to do this the easy way you'll need 2 columns
1 for the numbers, 1 for the hyperlinks., when entry is done,
you can simply hide the column with the numbers.

a1= 1000
b1= =hyperlink("http://www.example.com/number.cgi?"&a1)


to do it in 1 column you'd need to edit all the functions
to "hardcode" them, or you'd create a macro to insert 'm