Forum Discussion
Dates won't format
Hi everyone. I have this export where some dates are formated correctly and some are not in the same column. I have tried the obvious: date format, text to columns, =DATEVALUE, and pretty much all the solutions I have found online. Windows is also set to the correct date format.
I am about to go bananas due to this. Does any have a clue how to solve this?
Thank you.
6 Replies
date format won't work, Text to Columns shall if on third step of the wizard you select Date and MDY
Is it possible for you to post a copy of the spreadsheet itself? That would help us help you better than a description, especially given all the things you've already tried.
Thanks. hope you can help.
Here it is, I have removed some data that is not relevant. As you can see I also have problems with ',' and '.' in regular numbers. Easier to fix with find and replace. Still don't get it why some are formated correctly and some are not.
That is fixed by Text to Columns as above
