Hello,
I have a column of dates whose cells are currently formatted as text and are shown as mm/dd/yy. I want to change them to look like yyyy-mm-dd. I select the cells in questions to change the formatting. In the “Format Cells” window I change the category to “Date” and select “1999-12-31” under “Format”. I click Ok and the date still shows as mm/dd/yy, but it has an apostrophe caracter to the left of the date. if I delete the apostrophe, the date correctly shows as yyyy-mm-dd. I would hate to have to delete the apostrophe from each cell just so that it shows the date the way I’d like. Is there a way to stop Calc from adding the apostrophe?
Thanks,
franc