A folder contains 1100 excel workbooks of clients named based on their
account numbers.
A main file contains this

54625 hyperlink to D:\accounts\54625.xls
74351 hyperlink to D:\accounts\74351.xls
and so on...

I need a cell where i can simply enter 54325, and i should get a hyperlink
to D:\accounts\54325.xls in the next cell.
I tried using D:\accounts\ & 54325 & .xls and all, but that does not work..

Any other way to do this?
Thanks.