automate hyperlink within excel

I would like to know how i can automate a column with numbers to make a hyperlink to the corresponding pdf document in another directory, for instance number D00010 should make an hyperlink to 00010.pdf.