10/22 keeps changing to 22-Oct

Discussion in 'Excel' started by Primmrose, Mar 31, 2015.

  1. Primmrose

    Primmrose

    Joined:
    Mar 31, 2015
    Messages:
    1
    Likes Received:
    0
    I want to put 10/22 which is a gun, but it keeps changing it to 22-Oct, I have changed the format to number but it keeps changing it to the date. How do I get it to keep the 10/22 that I want?
     
    Primmrose, Mar 31, 2015
    #1
    1. Advertisements

  2. Primmrose

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    If you want to write 10/22 as text then put an apostrophe before it to tell Excel to keep it text. So, type '10/22 in the cell.
     
    Amy @ German Pearls, Feb 3, 2016
    #2
    1. Advertisements

  3. Primmrose

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Another way to do it (although Amy's is the easiest) is to format the cell as text before you enter 10/22.
     
    XLPadawan, Jun 14, 2016
    #3
    Amy @ German Pearls likes this.
    1. Advertisements

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.