hairymonster
New member
- Joined
- Dec 1, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Hi everyone,
I'm trying to enter dates into a spreadsheet, but excel is treating my keyed date as a Julian date and converting it as such.
I have formatted the field as a date field to be dd/mm/yyyy
So, I would expect to be able to key 251116 or 25112016 and see this convert to 25/11/2016. Instead it converts it to 11/07/2587!!!
I don't know what I have done to make this happen. Any ideas please?
Thanks - Philip
I'm trying to enter dates into a spreadsheet, but excel is treating my keyed date as a Julian date and converting it as such.
I have formatted the field as a date field to be dd/mm/yyyy
So, I would expect to be able to key 251116 or 25112016 and see this convert to 25/11/2016. Instead it converts it to 11/07/2587!!!
I don't know what I have done to make this happen. Any ideas please?
Thanks - Philip