Insert function

Discussion in 'Excel Beginners' started by Emrys Davies, Apr 19, 2014.

  1. Emrys Davies

    Emrys Davies Guest

    I am learning how to use Excel 2007. I have successfully entered column
    headings with a view to keeping a record of crown green bowling scores.
    However, when I enter 21/12 in an appropriate column it changes to 21-Dec.
    How can I ensure that this does not happen?
     
    Emrys Davies, Apr 19, 2014
    #1
    1. Advertisements

  2. Emrys Davies

    Claus Busch Guest

    Hi,

    Am Sat, 19 Apr 2014 16:18:58 +0100 schrieb Emrys Davies:

    > I am learning how to use Excel 2007. I have successfully entered column
    > headings with a view to keeping a record of crown green bowling scores.
    > However, when I enter 21/12 in an appropriate column it changes to 21-Dec.
    > How can I ensure that this does not happen?


    if you want to calculate with the values put them in 2 cells. If not
    format the cell as text before you enter the data.


    Regards
    Claus B.
    --
    Vista Ultimate / Windows7
    Office 2007 Ultimate / 2010 Professional
     
    Claus Busch, Apr 19, 2014
    #2
    1. Advertisements

  3. Emrys Davies

    Emrys Davies Guest

    "Claus Busch" <> wrote in message
    news:liu9ch$vtp$...
    > Hi,
    >
    > Am Sat, 19 Apr 2014 16:18:58 +0100 schrieb Emrys Davies:
    >
    >> I am learning how to use Excel 2007. I have successfully entered column
    >> headings with a view to keeping a record of crown green bowling scores.
    >> However, when I enter 21/12 in an appropriate column it changes to
    >> 21-Dec.
    >> How can I ensure that this does not happen?

    >
    > if you want to calculate with the values put them in 2 cells. If not
    > format the cell as text before you enter the data.
    >
    >
    > Regards
    > Claus B.
    > --
    > Vista Ultimate / Windows7
    > Office 2007 Ultimate / 2010 Professional


    Thanks a lot. It worked really well.
     
    Emrys Davies, Apr 19, 2014
    #3
  4. Emrys Davies

    Emrys Davies Guest

    "Emrys Davies" <> wrote in message
    news:...
    >
    > "Claus Busch" <> wrote in message
    > news:liu9ch$vtp$...
    >> Hi,
    >>
    >> Am Sat, 19 Apr 2014 16:18:58 +0100 schrieb Emrys Davies:
    >>
    >>> I am learning how to use Excel 2007. I have successfully entered column
    >>> headings with a view to keeping a record of crown green bowling scores.
    >>> However, when I enter 21/12 in an appropriate column it changes to
    >>> 21-Dec.
    >>> How can I ensure that this does not happen?

    >>
    >> if you want to calculate with the values put them in 2 cells. If not
    >> format the cell as text before you enter the data.
    >>
    >>
    >> Regards
    >> Claus B.
    >> --
    >> Vista Ultimate / Windows7
    >> Office 2007 Ultimate / 2010 Professional

    >
    > Thanks a lot. It worked really well.


    Claus B,

    I have successfully entered my team in Col. A and the first game's results
    in Col. B. Other teams take up columns C to AR. Points are entered in
    column AS and Shots are entered in column AT. Points and shots have
    'sorted' perfectly so far and that is all I wanted. Now my question. If
    after next week's game I enter the results in column C and 'Sort All' will
    the Points and Shots be updated automatically or am I expected to manually
    update those two and then 'Sort' them as I did for column B?
     
    Emrys Davies, Apr 20, 2014
    #4
    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.
Similar Threads
  1. jonna

    insert Microsoft Office 2000 Professional

    jonna, Feb 10, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    76
    Gord Dibben
    Feb 10, 2004
  2. Gary

    Need to insert a picture using a function

    Gary, Mar 4, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    75
    Ken Wright
    Mar 4, 2004
  3. robpearl
    Replies:
    3
    Views:
    102
  4. Jan K
    Replies:
    3
    Views:
    112
    Kassie
    Jul 20, 2005
  5. Paul

    "function" vs. "worksheet function"

    Paul, Mar 20, 2008, in forum: Excel Beginners
    Replies:
    6
    Views:
    113
  6. stephanieylalo

    how do i use the daye function to insert a serial number

    stephanieylalo, Feb 20, 2010, in forum: Excel Beginners
    Replies:
    1
    Views:
    74
    Gord Dibben
    Feb 20, 2010
  7. Superblonde64
    Replies:
    1
    Views:
    244
    Dave Peterson
    Feb 28, 2010
  8. Daryl Bachalo

    Adjust tab key function and enter key function in Excel

    Daryl Bachalo, Mar 20, 2010, in forum: Excel Beginners
    Replies:
    2
    Views:
    201
    Gord Dibben
    Mar 20, 2010
Loading...