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:
    24
    Likes Received:
    8
    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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.