Results 1 to 10 of 10

Thread: excell 2007

  1. #1
    SG Enthusiast horsemen_'s Avatar
    Join Date
    Mar 2002
    Location
    Edwards Air force base Ca
    Posts
    1,488

    Question excell 2007

    i made a football spread sheet but when i put in the w/l as 1-1 or 01-01 it makes it jan 1 how do i make it stop converting numbers to dates ?

  2. #2
    Senior Member Easto's Avatar
    Join Date
    Dec 2000
    Location
    So. California
    Posts
    5,045
    Format the cell as text

  3. #3
    SG Enthusiast horsemen_'s Avatar
    Join Date
    Mar 2002
    Location
    Edwards Air force base Ca
    Posts
    1,488
    when i click on text it has other options then what because nothing wants to leave the 1-1 2-1 alone it always chaging it to somehting

  4. #4
    Junior Member
    Join Date
    Oct 2006
    Posts
    18
    If you put something like 2-1 or 1-2 in excel it will treat it as an equation, giving you back the result. If you want to simply put 1-2 in a cell, you will need to precede it with a single quote mark ('). So, your cell would be typed in like this:
    '1-2

    Hope this helps.
    Ken

  5. #5
    SG Enthusiast horsemen_'s Avatar
    Join Date
    Mar 2002
    Location
    Edwards Air force base Ca
    Posts
    1,488
    ya thats what i doing now just seems there should be a way around that

  6. #6
    Junior Member
    Join Date
    Oct 2006
    Posts
    18
    Those are the only two ways I know, either preceding with the ' or formatting the cell as strictly text. You could always format the whole row, column, or even the whole sheet as text and you will not have to use the '...

    Ken

  7. #7
    Junior Member axdhakal1's Avatar
    Join Date
    Sep 2007
    Location
    Wichita,Kansas
    Posts
    36
    so cant we simply put 1-2 as horseman says.
    why cant this excel input these formatted datas / like 1-2? Bill sucks mann.
    "The big difference between sex for money and sex for free is that sex for money costs less."
    Brendan Francis.

  8. #8
    Junior Member
    Join Date
    Oct 2006
    Posts
    18
    If all you want to do is enter text into a table, create a table in Word and work with it there. The reason Excel makes you jump through hoops is that it is primarily a spreadsheet, developed to work with numbers in terms of equations, not just for formatting.

    Ken

  9. #9
    Senior Member loop2kil's Avatar
    Join Date
    Jun 2000
    Location
    Atlanta, GA
    Posts
    5,230
    In all honestly what Easto said will work...or at least it did for me.
    format the cell to 'text', then whatever you type is what will appear. the '=' sign needs to be used first for it to be considered an equation.

    example: 2-1 showed up as 2-1

  10. #10
    Senior Member loop2kil's Avatar
    Join Date
    Jun 2000
    Location
    Atlanta, GA
    Posts
    5,230
    if you already have something in the cell and then try to format it to 'text' it will change to something weird, so make sure to format all the cells before you start typing.

Similar Threads

  1. Modem Resets Randomly. At my wits end.
    By Goshinga in forum General Broadband Forum
    Replies: 6
    Last Post: 09-02-11, 05:57 PM
  2. Media and its bias against Iraq war
    By Ghosthunter in forum General Discussion Board
    Replies: 45
    Last Post: 05-02-07, 12:40 AM
  3. the best place to buy Xbox games???
    By panicattack in forum Marketplace - Buy/Sell/Trade/Hot Deals
    Replies: 13
    Last Post: 04-23-07, 05:43 PM
  4. I keep getting this PPP down error any time i play mmo's
    By Anamnesis in forum Networking Forum
    Replies: 2
    Last Post: 04-04-07, 11:16 AM
  5. DSL Connection Loss
    By StaticShock in forum General Broadband Forum
    Replies: 1
    Last Post: 03-08-07, 12:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •