Well when you have something in a cell right click and then press hyperlink that will keep the Number. I don't know how to automate that though without VBA.