Adding data to cells

[Thomas Zorn]

I opened a text file in excel for a database for a mail
merge. The zip field loaded 2,500 records but dropped the
first zero, leaving only 4 digits in each cell of the
column. Is there a way to add the leading zero into each
cell (while maintaining the current data) so that the
cells will contain the proper 5 digits?

 

[Peo Sjoblom]

Use zip code format 00000