It compresses or truncates because there is not enough space to show the full
text. I am not sure where you are attempting to display it, but the answer
is to provide sufficient space, use linewrap, multiline or some other feature
to provide adequate space.

"coless2001" wrote:

I'm trying to display the text of a hyperlink and have used many of the
methods described in this discussion group, but my links seem to have a
problem. When I right-click to "Edit Hyperlink", the link is displayed as
"..\..\Sales\Business Cases\NewProject.xls". The link works fine if you
click on it and the text displayed when you hover over the cell shows the
full path, but all of the methods to display the hyperlink show the
"...\...\". Anyone know how I can get the full path without this truncation?