Insert leading zero in a zip code

[decook]

I created a .csv file from another program that included as one of the columns a zip code. If the zip code starts with a zero, the zero was dropped.

Can anyone tell me how to tell Excel XP to look for a four digit number and add a zero to the front of it if it is four digits?

Something like, If I2 is 4 digits, add a zero to the beginning.

Thanks in advance,

Kent

 

[Cbrine]

Sorry messing up my MSAccess with my MSExcel
Should be

=REPT("0",5-LEN(A2))&A2

A2 being your cell.