HYPERLINK using a date in a cell
 

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.

HYPERLINK using a date in a cell
 

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")
--
David Biddulph

"Ron@Buy" wrote in message
...
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.

HYPERLINK using a date in a cell
 

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

"David Biddulph" wrote:

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")
--
David Biddulph

"Ron@Buy" wrote in message
...
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.