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. Advertisements

  2. Emrys Davies

    Claus Busch Guest


    Am Sat, 19 Apr 2014 16:18:58 +0100 schrieb Emrys Davies:
    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.

    Claus B.
    Claus Busch, Apr 19, 2014
    1. Advertisements

  3. Emrys Davies

    Emrys Davies Guest

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

    Emrys Davies Guest

    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
    1. Advertisements

Ask a Question

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.