How do I keep my zip code column from rounding the number up?

[Dee]

I have unlocked the sheet, set the decimal point to 0 . How can I keep the
system from rounding up my zip from 77598 to 776?

 

[BenjieLop]

Two ways:

1. Format/Cells/Text

2. Format/Cells/Special/Zip Code

Take your pick.

 

[David McRitchie]

Hi Dee,
You amounts are already entered,
won't be effective until they are reentered. You can't just reenter
what you see, because the decimal point has already been inserted.
Try this for those that were entered with a fixed decimal of 2.

If you have them formatted as numbers then format them
as 00000 Formatting of numbers will take place immediately
but you want to still multiply by 100.

Place 100 into a cell and copy it (ctrl+c)
Then select the old entries (all of them) and then

Edit, GoTo (ctrl+G), constants & numbers
Edit, Paste special, Multiply

I would recommend in the future to only use TEXT formatting for
zip codes of any country, including the US.