Why is a cell formatted as a zip code is showing up as a decimal?

[Guest]

I have a spreadsheet with names and addresses that I've been continually
adding information to on a weekly basis. Now, all of a sudden this week my
zip code column is showing the zip codes as decimals. Previously, all cells
were a general format and everything worked fine. With this new problem, I
changed the column format to the zip code format. It worked with every cell
except for one. I'm pretty knowledgeable about Excel so this one has me
baffled. I've changed the format on this cell to everything imagineable. I've
even tried filling the cell from the one above or below with formatting only.

 

[Guest]

Edit > Clear > Formats (It will clear whatever the format you have in that
cell), then apply your desire format.

 

[Guest]

I'm pretty savvy with Excel, so I've done everything I can think of and more.
It still happens no matter what I do. I've deleted the contents, cleared
formatting, changed to every format, and my zip codes still show up as a
decimal. For example 98368 shows up as 983.68 or 00987 depending on the mood
of the day, apparently.

 

[Guest]

I've solved the issue. Thank you!

 

[David Biddulph]

If 98368 shows up as 983.68, try Tools/ Options/ Edit, and uncheck "Fixed
decimal Places".