How do I make a number start with a zero in a table?

[kath]

Hi,
I'm trying to use access to create mailing labels and everything is going
fine except when I import my excel table in to access my zip code field
changes. Zip codes that start with zeros lose the zeros on the beginning of
them. Is there a simple way to correct this?

 

[Klatuu]

Your zip code field is probably a number. It should be text to preserve
leading zeros. You can fix it using the format function:

=format(zip,"00000")