Rita

In later versions you can go to ToolsAuto correct options... and select the
'autoformat as you type' tab, un-checking the 'internet and network paths
with hyperlinks' entry

Other versions, hitting Ctrl+Z straight after entry (Undo). It will undo the
formatting but not the entry. Pain, but that's about all you can do

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"rita" wrote in message
...
I do not want the cell format to change when I add a hyperlink. Presently,
the font, colour and underscore changes whenever I add a hyperlink. As I
shall be adding links over a period of time, I do not wish to keep
changing
the formatting all the time. Is there a way of avoiding having to do this?
(like how do I change the default for hyperlinks?)