Hyperlink, cell data with zeros

[Poiuytresa]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a worksheet where the numbers in a column are linked to a pdf file<o></o>
The formula is:<o></o>
<o> </o>
=HYPERLINK("c:\testing\123\Map"&b2&".pdf",b2)<o></o>
<o></o>
The column B is a list of numbers with 5 digits and some numbers start with zeros, eg. 00010, 01234 ...<o></o>
<o></o>
The formula works fine when the numbers don’t start with zeros (12345…), but when the number starts with zero the formula doesn’t recognize the hyperlink (I think the formula is not recognizing the zeros before the number, changing 00010 to 10).<o></o>
<o></o>
I’ve tried to change the format of the data but it still not working.<o></o>
<o></o>
Any idea?<o></o>
<o></o>
Thanks <o></o>
<o> </o>

 

[Peter_SSs]

Try:
=HYPERLINK("c:\testing\123\Map"&TEXT(b2,"00000")&".pdf",b2)

 

[Poiuytresa]

Thank you !!!