Using dates with hyperlinks
 

i am using a very large spreadsheet with hyper links to related word files.
These hyperlinks are created automatically based on cell contents. but i am
having trouble when using a date formatted cell. currently i am using the
format ddmmyy, but when it is used as i hyperlink, its reverts back to the
serial number. is there any way to stop this?

hope i explained that right!

Try creating a folder on your desktop and dumping the word files into it.
I have a lawn mower and I would not use it to paint a house.

"jeegna" wrote:

i am using a very large spreadsheet with hyper links to related word files.
These hyperlinks are created automatically based on cell contents. but i am
having trouble when using a date formatted cell. currently i am using the
format ddmmyy, but when it is used as i hyperlink, its reverts back to the
serial number. is there any way to stop this?

hope i explained that right!

Either edit the hyperlink the way you want--or even use the =hyperlink()
worksheet function.

If you put a date in A1, you could use:
=hyperlink("file:////c:\my documents\word\" & text(a1,"mm_dd_yyyy") & ".doc")

(Build a string that matches the file name.)

jeegna wrote:

i am using a very large spreadsheet with hyper links to related word files.
These hyperlinks are created automatically based on cell contents. but i am
having trouble when using a date formatted cell. currently i am using the
format ddmmyy, but when it is used as i hyperlink, its reverts back to the
serial number. is there any way to stop this?

hope i explained that right!

--

Dave Peterson

cheers dave exactly what i was looking for.

"Dave Peterson" wrote:

Either edit the hyperlink the way you want--or even use the =hyperlink()
worksheet function.

If you put a date in A1, you could use:
=hyperlink("file:////c:\my documents\word\" & text(a1,"mm_dd_yyyy") & ".doc")

(Build a string that matches the file name.)

jeegna wrote:

i am using a very large spreadsheet with hyper links to related word files.
These hyperlinks are created automatically based on cell contents. but i am
having trouble when using a date formatted cell. currently i am using the
format ddmmyy, but when it is used as i hyperlink, its reverts back to the
serial number. is there any way to stop this?

hope i explained that right!

--

Dave Peterson