View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meenie Meenie is offline
external usenet poster
 
Posts: 192
Default Problem with date - can't enter 15th!

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??