View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to enter a non-standard format hyperlink

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