Hi Dean

excel doesn't know what you've entered into a cell, it only recognises the
"type" of data (text, number, date etc) .. so it won't know that you've
entered zip codes and therefore won't "treat" them in a special way.

However, i'm interested in HOW you formatted the cells to show the leading
0, as when i do this using format / cells / custom ... and type in 00000 and
click OK
the leading zeros not only show up in the cell they show when i do print
preview ... so i'm not sure why your zeros show in the cell but not in print
preview.

Hope this helps
Cheers
JulieD

" wrote
in message ...
Help...When I format a zip code file it appears in the field to show the
"0"
at the beginning of the field but it does not show when I print. The only
work around is change it to text. I thought a zip code would recognize it
as
a zero. any idears....
--