Fixing ZIPCODES while converting data

[Newbie1]

Is there a way to fix zipcodes while migrating data from one worksheet to
another? I have the columns filled with
=PROPER(Sheet1!A2) =PROPER(Sheet1!B2) etc, so I am looking for a proper
function that will "fix" the zipcodes and force them as leading zero (if
needed) based text. So something that can be called like =FIXZIP(Sheet1!H2)
Or is there a simpler way?
Thanks
BPJ

 

[Tom Ogilvy]

=right("00000" & Sheet1!C2,5)

or

=Text(Sheet1!C2,"00000")

for 5 digit zip codes

 

[Newbie1]

Thanks!
This also seems to handle the 5+4 zips I have as well!
BPJ