Custom Formatting a cell

[GeorgeCunn]

https://sk4.xxxxxx.com/#/customers/807286/Activities

I don’t know if it is possible, but I want to enter a six digit number in a cell, (in this example the number 807286), and turn the number into a hyperlink with just the number showing in the cell.

Is this possible using “Custom Format” in the cell?

Thanking you in advance.

 

[JoeMo]

Have you tried selecting the cell where you want the link then Insert>Links>Insert Link and enter the number in the "Text to Display" box?
In the example below, a cell in Sheet4 contains the hyperlink to cell A1 in Sheet10.

 

[GeorgeCunn]

Thank you JoeMo for your reply

Yes. I probably wasn't clear with my question. Column C, E & F have 99 rows. Each sales rep will enter a specific customer # so the entered number will always be different. When they work in the spreadsheet, they can click the link and it will take them to the appropriate page in our CRM program.

Hopefully this is a little clearer.

 

[JoeMo]

Thank you JoeMo for your reply

Yes. I probably wasn't clear with my question. Column C, E & F have 99 rows. Each sales rep will enter a specific customer # so the entered number will always be different. When they work in the spreadsheet, they can click the link and it will take them to the appropriate page in our CRM program.

Hopefully this is a little clearer.

I don't open links on the web so haven't looked at the URL you posted. Maybe someone else can help.