I have converted a pdf to an xls and in calc the date fields are as text ‘dd/mm/yyyy. Formatting the cells as date does not work until I manually delete the apostrophe (’). Find and replace does not seem to find this character at all so I can’t remove it automatically. Can anyone help?
Thanks. It hard to figure just what to ask in order to find an answer. I thought I’d searched thoroughly
BTW:
Never use an example date in a slash format not allowing to distinguish the global (and British) format in D/M/Y order from the US-only format in M/D/Y order.
22/09/2014 e.g. doesn’t only tell “I’m a date”, but also 'I’m giving day, month, and year in a somehow reasonable order.
Strictly speaking, however, only the “ISO 8601 extended” date format YYYY-MM-DD is reasonable nowadays in a globalised world.
(Also see this sketch.)
Spoken aside: Any forum / askbot site on software, in specific one with a global scope, should exclusively use the mentioned standard for dates. No hope insofar!
This site is joking about the matter. It uses absurd formats definitely invented for fun only.