Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |