Excel problem

Discussion in 'Computer Support' started by Jan, Nov 24, 2003.

  1. Jan

    Jan Guest

    I'm helping a friend with Excel. She has a spreadsheet that we set up with
    the first column being the date. I formatted the cell as "general" for her
    so that she could put in the month and day, then only the day in the
    following rows, (e.g.. first column Oct 10, second row 11, and so on until
    November). The problem is that she keeps calling me telling me that when you
    puts the, say 11 in it resorts back and inserts Jan 11. I keep going back
    and reformatting the cells to take as "general" and it works find. Then when
    she closes out and comes back to it later, all the formatting has changed
    back. I have protected the worksheets, but unprotect to make the changes,
    then protect again after I finish. I also highlight the entire column to do
    the formatting to insure the entire column is included. One more bit of
    info, there are several identical sheets she is using, and I change EACH
    one, then only some don't take, or resort back. What am I doing wrong? This
    is the blind leading the blind.....Thanks!
    Jan, Nov 24, 2003
    1. Advertisements

  2. Jan

    Jammer Guest

    Try to format cells with the date format and put the cursor to the bottom
    right and drag the cusor downward and see if this helps.
    Jammer, Nov 24, 2003
    1. Advertisements

  3. Try formatting the cells as /text/, not /general/. They should then accept
    what you enter as a plain string, and not try to figure out what you
    meant -- there's interpretation involved with the general format, and
    you don't want or need that, for what you're looking for.
    Blinky the Shark, Nov 24, 2003
  4. Jammer, if he formats as date, he's not going to get what he wants, entering
    nothing but an integer ("11" in his example).
    Blinky the Shark, Nov 24, 2003
    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.