Editing a cell in Excel spreadsheet

Discussion in 'General Discussion' started by nnorris, Apr 24, 2018.

  1. nnorris


    Apr 24, 2018
    Likes Received:
    I am using Excel on windows 10. When our mailing list was transferred from another computer it didn't save the zeros on the zip code. When I try to put them in, it won't save them. What is wrong?

    nnorris, Apr 24, 2018
    Abraham Andres Luna likes this.
    1. Advertisements

  2. nnorris

    Abraham Andres Luna

    Mar 14, 2018
    Likes Received:
    Spring Hill, FL 34608
    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'
    Abraham Andres Luna, Apr 24, 2018
    Becky likes this.
    1. Advertisements

  3. nnorris

    Becky Webmistress Administrator

    Mar 25, 2003
    Likes Received:
    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.
    Becky, Apr 25, 2018
    Abraham Andres Luna likes this.
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.