Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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?