Zip-Code Format Issue

When I format cells for standard 5 digit zip codes, the leading 0 is displayed in the cell but the leading 0 is not displayed in the formula bar.
When I merge to MSWord to create labels, the leading zero is missing.
Can anyone help?

Hi

A workaround maybe???

Excel cell will drop the leading zero and read 04579 as 45678 in the cell (the leading zero may refer to a zip code). A leading zero is not recognised by Excel as part of a number. However, if you insert ‘045678 the cell will show 045678, the leading apostrophe does not show in the cell, but does show in the formula.

Try setting your cells to Format > Cells > Number > Text, then enter your numbers