Forum Discussion
Formatting Birthdates Issue
I have been having some trouble with getting some birthdates formatted the way I want. They are part of a report imported from my company's system in a .txt file that I converted to .xlsx. When I wen...
You can't change the value by just formatting. Number 1131949 means that's day number 1131949 starting from January 1, 1900. Same way as today, July 11, is day 45118 from the Excel calendar start.
You may convert by formula, but that's not clear do always have 8 digits numbers or not.
If not, for example 1111949, it's not clear that's Nov 01 or Jan 11 in 1949.
- SergeiBaklan Yeah, I've pretty much come to the decision that I'm stuck manually correcting each of these 2k+ dates by inserting the / myself. I'll have to speak with our IT for our system about correcting it in the core to hopefully prevent this in the future.
