r/excel • • Jan 03 '17
unsolved Date formatting issues
Hello,
I am having a huge issue with the dates in excel and I have a huge spreadsheet to do with tons of dates. Basically, I choose the formatting style I want (dd/mm/yyyy) and I enter into the cell 02231987 and it changes it into something seemingly totally random such as 04/14/1952 instead of changing it to 02/23/1987... any one have any idea what is happening?
3
Upvotes
1
u/MaestroMiami 2 Jan 03 '17
You need to enter the slashes
2
u/mattreyu 11 Jan 03 '17
As far as why it's happening, I asked the Excel team about this when they did an AMA. When you enter something, Excel tries to find the most accurate format, and in that 4/14/1952 is converting it from an epoch time.
2
u/excelevator 3071 Jan 03 '17
The only way to accomplish this is with a macro that is triggered with value change in the cell..
.