How to enter a non-standard format hyperlink

[jcotter]

I need to be able to enter a hyperlink into a cell with this format:

http://0/script.mq?HC ...

However, every time I enter this, Excel autocorrects this to:

http://0.0.0.0/script.mq?HC ...

Is there a way to prevent Excel from performing this correction?

 

[Dave Peterson]

xl2003 doesn't do any conversion for me.

Any chance you have an autocorrect entry that's jumping in?

In xl2003 menus, tools|autocorrect options|autocorrect tab

But it could be a couple of different things...

http://0/
replaced with
http://0.0.0.0/

You may want to scroll down the list.

In fact, if you hit ctrl-z right after the "helpful" conversion takes place,
it'll return to what you typed.

(Ctrl-z is the shortcut for edit|Undo)