I have a data file that provides this date and time stamp in the following manner: May 24 2016 - 10:08pm
And I need to format it for 2 different profiles due to different user settings: mm/dd/yyyy with the time stamp removed AND dd/mm/yyyy
If anyone can offer assistance, that would be great.
When I click on the cell nothing changes, the contents of the cell still present as May 24 2016 - 10:08pm. Also when checking the Data-Sort, the options are A->Z and Z->A, not a date.
I'm having a similar problem, though there is no timestamp in the original file. I continue to get an "Invalid Fuzzy Date" error for a birth date field. I checked the cell value and the formatting and there is no timestamp. I tried deleting the column and entering the value manually (rather than rely on the source file). Any suggestions? I don't see a timestamp anywhere in the cell. Thanks.
I added a dictionary. It solved my problem.
Thanks John. This worked. Excel does some strange things...