Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Imported csv date formatting adds an apostrophe to the beginning of dates

Version: 6.0.3.2 Mac OS High Sierra 10.13.4

When I import a csv file and format the date column, LO adds an apostrophe to the beginning of each date. This apostrophe is only visible in the formula field. It's really weird. How can I stop this behavior?

It looks like this is an old problem, as I found an old, unanswered thread on this: https://ask.libreoffice.org/en/question/59910/why-does-format-column-to-date-insert-apostrophe-08032015/

Imported csv date formatting adds an apostrophe to the beginning of dates

Version: 6.0.3.2 Mac OS High Sierra 10.13.4

When I import a csv file and format the date column, LO adds an apostrophe to the beginning of each date. This apostrophe is only visible in the formula field. It's really weird. How can I stop this behavior?

It actually prevents the date from formatting correctly. I had formatted it to MM/DD/YY and at first I couldn't figure out why the formatting didn't 'take'. When I took a closer look, I saw the little apostrophe up in the formatting bar.

It looks like this is an old problem, as I found an old, unanswered thread on this: https://ask.libreoffice.org/en/question/59910/why-does-format-column-to-date-insert-apostrophe-08032015/

image description

Imported csv date formatting adds an apostrophe to the beginning of dates

Version: 6.0.3.2 Mac OS High Sierra 10.13.4

When I import a csv file and format the date column, LO adds an apostrophe to the beginning of each date. This apostrophe is only visible in the formula field. It's really weird. How can I stop this behavior?

It actually prevents the date from formatting correctly. I had formatted it to MM/DD/YY and at first I couldn't figure out why the formatting didn't 'take'. When I took a closer look, I saw the little apostrophe up in the formatting bar.

It looks like this is an old problem, as I found an old, unanswered thread on this: https://ask.libreoffice.org/en/question/59910/why-does-format-column-to-date-insert-apostrophe-08032015/

image description