I'm a complete idiot when it comes to Excel. I did search on the forum, but couldn't find anything that worked for what I need.

I have a cell that is blank. When I enter text into it, which will be a 6 digit number, I need to have a hyperlink created.

So as the example, in the blank cell D19, I enter in 123456. The URL that the hyperlink needs to point to is http://server.domain.net/apps/123456?OpenDocument

The text that is displayed should just be the 6 digit number I entered.

I've tried different things but nothing seems to work. Any help would be greatly appreciated.