Excel problem

Hi,
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!

 

Hi,
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.

 

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.

 

Jammer, if he formats as date, he's not going to get what he wants, entering
nothing but an integer ("11" in his example).