I'd try:
=hyperlink("http:////appserver\users\FILE 02-\"&a1&".xls","Clickme")

or maybe if that number had to be formatted nicely:
=hyperlink("http:////appserver\users\FILE 02-\"&text(a1,"000")&".xls","Clickme")

rajaiy wrote:

Dears,

I have one excel sheet, I need to make auto scrol doun fore the hyperlink,
like this example,

a1 = 419 b1= \\appserver\users\FILE 02-\419.xls.

so how I can make auto hyperlink as the next cell will call the next file no
150 from the same folder as .

a2 = 420 b2= \\appserver\users\FILE 02-\420.xls.
and go on.

Thanks for help...

--

Dave Peterson