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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
Back
Top