How to convert '02/02/2014 for example, to a proper date [closed]

asked 2019-10-27 11:23:48 +0100

patbell101 gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by patbell101
close date 2019-10-27 12:58:09.718152


Mike Kaganski gravatar imageMike Kaganski ( 2019-10-27 11:31:42 +0100 )edit

Thanks. It hard to figure just what to ask in order to find an answer. I thought I'd searched thoroughly

patbell101 gravatar imagepatbell101 ( 2019-10-27 12:57:45 +0100 )edit

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.

Lupp gravatar imageLupp ( 2019-10-27 13:43:57 +0100 )edit