I'm using Excel 2002. Here's is what I'd like to do...imagine a
column of whole numbers which represent anything...a 5 digit zip code
for example. I'd like a function or formula that I could apply to all
the cells in the ZipCode column. This function would hyperlink to a
url which includes the zipcode. I believe this is called a circular
reference. I'd like this automated or done as effortlessly as
possible. Here is how I currently accomplish this...enter the zip
codes into the spreadsheet; go to the url which includes the zip code
in the url path; highlight the url and copy <ctrl-c; create a
hyperlink in the corresponding cell and paste <ctrl-v the url. This
is very cumbersome. That probably isn't very clear but any help would
be greatly appreciated. Thanks, Mike

Here's something a bit easier, but not quite what you asked for.

Suppose column A is a list of zip codes.

In B1, put (for example)
=HYPERLINK("http://www.weather.com/outlook/homeandgarden/garden/tenday/"
&TEXT(A1,"00000"),TEXT(A1,"00000"))
all in one line, of course. Then copy down.

To update the list, change column A. Then you can hide column A and click
on column B.