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?

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.
Similar Threads
  1. jonna

    insert Microsoft Office 2000 Professional

    jonna, Feb 10, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    91
    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:
    94
    Ken Wright
    Mar 4, 2004
  3. robpearl
    Replies:
    3
    Views:
    120
  4. Jan K
    Replies:
    3
    Views:
    131
    Kassie
    Jul 20, 2005
  5. Paul

    "function" vs. "worksheet function"

    Paul, Mar 20, 2008, in forum: Excel Beginners
    Replies:
    6
    Views:
    136
  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:
    91
    Gord Dibben
    Feb 20, 2010
  7. Superblonde64
    Replies:
    1
    Views:
    272
    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:
    228
    Gord Dibben
    Mar 20, 2010
Loading...