Editing a cell in Excel spreadsheet
- Thread starter nnorris
- Start date
Abraham Andres Luna
Child of God
- Joined
- Mar 14, 2018
- Messages
- 699
- Reaction score
- 227
It sounds like you are trying to save the zip code as a raw number. Excel will remove the leading zeros because it doesn't need them to represent the number. If you want to save a zip code with zeros you have to wrap it in apostrophes like this '00790'
Becky
Webmistress
- Joined
- Mar 25, 2003
- Messages
- 7,424
- Reaction score
- 1,511
Agreed, although technically you only need to put one apostrophe (at the start). This is also useful when you want a formula to appear as text - eg '=1+2 would appear as =1+2 rather than 3.
If you don't want to edit an apostrophe into each cell, you can achieve the same thing by formatting the cells as text - right click on the highlighted cells, select Format Cells, then choose the 'Text' option from the category list.
If you don't want to edit an apostrophe into each cell, you can achieve the same thing by formatting the cells as text - right click on the highlighted cells, select Format Cells, then choose the 'Text' option from the category list.