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.

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

"Renee'" wrote:

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.

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.

"Teethless mama" wrote:

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

"Renee'" wrote:

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.

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

"Renee''" wrote in message
...
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.

"Teethless mama" wrote:

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

"Renee'" wrote:

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.

I've solved the issue. Thank you!

"Renee'" wrote:

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.