Disabling hyperlink in excel 2K

[Spiggsy]

Does anyone know how to do this as a default ?
All our old analysis sheets had times entered as 15hours@doubletime which are now becoming hyperlinks. Any ideas how to disable this as a default would be hugely appreciated.

Cheers,

Spiggsy.

 

[JVFriederick]

What about replace "s@d" with "s @ d" ?

Will this break the link?

 

[Spiggsy]

Oh yes that works, as does forcing text format with the '
It's more a curiosity now of if I can disable the hyperlinks rather than needing too do it in this instance.

 

[luceze]

The easiest way to get rid of a hyperlink is to right click on the hyperlink and select disable hyperlink. I'll see if I can find a way to disable it for the whole sheet.