Excel 2003
I have a worksheet with many rows containing text and dates across columns.
Dates are entered using dd/mm/yyyy format and a slave hidden column converts
the date to a yyyy-mm-dd format.
I have constructed a hyperlink on the worksheet using concentated text and
date to point to a .pdf file on a server. Part of the .pdf file name contains
the date in the yyyy-mm-dd format. The hyperlink works perfectly if I include
the date in the hyperlink (e.g. "2008-03-05") but if I replace this with the
cell reference (from the slave column) containing the date, the hyperlink
fails. This is because the date in the cell is picked up as a number!
How can I enter the cell reference into the hyperlink so it will connect?
Your help would be much appreciated.