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!