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