Hoping anyone can help me with the issue I’m having.
In some of the date lines that I imported from multiple spreadsheets, I noticed there are a few that did not convert to proper excel date format (5 digit numbers).
The issue stemmed from the data source (won’t convert to numbers when I changed the data type to number or text), however I can’t pinpoint the case, as there is no leading or trailing spaces on the data on it
Is there any way to remove this inconsistency through EasyMorph at all?
Thank you in advance.