HYPERLINK using a date in a cell

[Ron@Buy]

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.

 

[David Biddulph]

If you are picking up the date as a number and want it as a date in your
format, you may wish to use TEXT(cell_ref,"yyyy-mm-dd")

 

[Ron@Buy]

David
Two problems, I can't spell (concatentated!) and can't see the wood for the
trees!
Thank you for showing me the way, it's so obvious when you know how. I don't
even need the slave column.
Again, many thanks