Help please! Hyperlink created from cell contents doesnt see zeros

[sniffmyface]

Hi there.
Really hope someone can help as i am drawing a blank.

I have 2 columns next to each other - column H has the hyperlink that has been created using the contents of column I.

Column I contains project numbers in a "P00001" format. I have these cells auto formating so the user can enter any number and it will be converted into the "P00001" format.
Column H contains the link and a friendly name of photos. When clicked, i want it to open the folder relating to the project number, which will contain all photos for that project.

I am using the formula =HYPERLINK("folder destination"&I10,"Photos") to create the link, but it doesnt work as the link doesn't see the "P" or the zeros in the cell. So instead of the url being (example) c:\photos\P00001 it is showing c:\photos\1.


Hopefully i have explained this correctly. And hopefully someone can explain how i can fix this as it is driving me mad!!!!

Thanks in advance.

[Ace_XL]

Try

=HYPERLINK("folder destination"&TEXT(I10,"P00000"),"Photos")

[sniffmyface]

Brilliant. This worked perfectly after tweaking to suit my needs. Thank you very much!!!