Forum Discussion
Cannot format cells with dates to mmddyyyy
Using Office 365 - I am copying a notepad document to Excel to manipulate the data to fixed with columns. Within the notepad document there are three columns that contain dates. When they are copie...
Strange that something that has worked should now fail. Is importing the data as a formal ETL step using PowerQuery an option for you? That allows finer control over the conversion between dates with different localisations than is possible using the automatic conversion of text in Excel.
If you are stuck with importing directly to the grid, then preformatting the range to text can block the automatic conversion, leaving you to sort the results using text manipulation formulas. Text to columns can also provide some conversion support.
As Harun24HR says, a sample of the data would be useful, and the problem would be easiest solved by someone using US/Liberia date settings on their computer.