Leading Zero Zip Codes

[Welsh Mark3]

I'm losing leading zeros in my Zip code fields. I have another formula that is reliant on ZIP code being a 5 digit text value.

I have tried using the formula - =TEXT(A2,"0"), I have also tried using format cells function and customing to '00000'

Does anyone have any recommendations?

 

[shg]

=TEXT(A2, "00000")

 

[Fluff]

How about
=TEXT(A2,"00000")

 

[Welsh Mark3]

Perfect thank you

 

[Fluff]

Glad we could help & thanks for the feedback