Editing a cell in Excel spreadsheet

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

  1. nnorris

    nnorris

    Joined:
    Apr 24, 2018
    Likes Received:
    1
    HI,
    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?

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

  2. nnorris

    Abraham Andres Luna

    Joined:
    Mar 14, 2018
    Likes Received:
    90
    Location:
    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'
    :thumb:
     
    Abraham Andres Luna, Apr 24, 2018
    #2
    Becky likes this.
    1. Advertisements

  3. nnorris

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,322
    Location:
    Manchester
    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
    #3
    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.