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)
jcotter wrote:
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