Example: 01/01/2006 turned into 10/10/4670
???

"DonnaD" wrote:

I have formated a cell range for dates, but Excel completely changes the
numbers I input to these cells. I have checked my computer's regional
settings - OK. This has happened on several spreadsheets.