1. Welcome to SportsJournalists.com, a friendly forum for discussing all things sports and journalism.

    Your voice is missing! You will need to register for a free account to get access to the following site features:
    • Reply to discussions and create your own threads.
    • Access to private conversations with other members.
    • Fewer ads.

    We hope to see you as a part of our community soon!

Excel help

Discussion in 'Anything goes' started by Diabeetus, Jan 6, 2008.

  1. Diabeetus

    Diabeetus Active Member

    I know I learned this at some point in the past, so feel free to mock me.

    In Excel, how to do you keep things (such as team records) from being converted to dates? I want 1-1 to stay 1-1 and not become 1-Jan.

    Help is much appreciated. Thanks in advance!
     
  2. Eagleboy

    Eagleboy Guest

    Right Click, choose Format, and set the cells to be nothing but Text (should be an option on the left).

    I'm doing that from memory, so hopefully it's close enough to exact.
     
  3. EStreetJoe

    EStreetJoe Well-Known Member

    Or he could just have wins and losses in separate columns and avoid the problem altogether.... unless of course he needs the entire record in one cell.
     
  4. Diabeetus

    Diabeetus Active Member

    Record did just need one cell, so I took Eagleboy's help and got it going. Thanks! :D
     
Draft saved Draft deleted

Share This Page