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 th...
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
What? That is absolutely crazy. Would have never guessed that the solution is choosing a different format than the one you want. Thank you so much. You have saved my sanity!
