The autocorrect works. And it was for the number 15! It had it to be replaced
with 16. How would that get in there??
Thanks!

"Glenn" wrote:

Look at Tool / AutoCorrect Options to see if there is an entry that accounts for
what you are seeing.

Meenie wrote:
I tried the apostrophe and it still changed from 1/15 to 1/16,
I tried changing the format to "text" and it still changed!!
this is too weird!

"Dave Peterson" wrote:

Either preformat the cell as Text, then do the data entry.

Or

Start your entry with an apostrophe:
'1/15



Meenie wrote:
I have excel 2003
I have a spreadsheet and on one worksheet I enter the date that documents
are turned in.
the cells are formatted to date and to show up like 1/10
Problem: I can't eneter 1/15! I can enter 1/14 and I can enter 1/16 but if I
enter 1/15, it changes to 1/16 as soon as I either hit enter or click into
another cell.
what's up with this??
--

Dave Peterson