Hi all,
The problem is when I open a .csv with a bunch of American dates in it Excel formats all the days that are before the 12th of the month as UK dates and it formats the rest as text.
I made this formula today based on what people have said in the past on this forum.
Has anyone got a shorter formula for solving this problem? What I have seems a bit excessive for what it's doing.Please Login or Register to view this content.
Yes I'm sharing this so if other people want to do the same thing it is here.
Bookmarks