Excel changing dates

Copper Contributor

Excel is changing my dates.  I have formatted the column for DATE.  I enter 11/30/18 and it changes the date to 6/6/2209.  If I enter 12/02/18 it returns 2/21/2229.  How do I correct this?

 

0 Replies