Forum Discussion
Excel Changes Date Day to Year
I have a financial ledger where I input date purchased so I'm only working in current year. Excel has been no problem with my method for years but out of the blue it is correcting my dates. I always ...
how about changing your method? just enter 9/19 instead of sep 19 -- I'm pretty sure it will recognize that as 9/19/22; and it's fewer key strokes
mathetes not a bad idea but unfortunately it still changes 9/19 to September 1, 2019.
- Strange. Mine accepts that kind of entry in the way you (and I) want it to. And I don't see an item under Excel....Preferences... to change the way dates are handled, something that might have inadvertently been set to a different preference. Only other thing I would suggest checking is the custom formatting options.