CODEWITHSUNDEEP
excelhyperlink
Furqan Tariq
Furqan Tariq

Reputation: 73

Prevent Excel truncating leading zeros for HYPERLINKS

Please note this question is for hyperlinks so do not mark it as duplicate without actually looking at the problem. I know we can prevent excel from truncating leading zeros by setting the cell format to text. That works. However, when I add a hyperlink and in its text to display I add a value like 00111, the hyperlink name is truncated.

Is there any way to prevent that?

enter image description here

Upvotes: 0

Views: 239

Answers (1)

Forward Ed
Forward Ed

Reputation: 9874

instead of formatting the cell as TEXT, how about turning the number into text first and then turning it into a hyper link.

Upvotes: 1

Related Questions