Ask Your Question

Trouble formatting date cells in Calc [closed]

asked 2012-10-02 01:51:55 +0200

ciccio70 gravatar image


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?



edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 21:08:07.785786


Hi mariosrv. It worked. Thank you so much!

ciccio70 gravatar imageciccio70 ( 2012-10-02 04:04:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-10-02 02:48:03 +0200

m.a.riosv gravatar image

updated 2013-01-25 00:09:53 +0200

If a cell is formatted as text (@) then everything you enter in the cell is treated as text.

You can eliminate all the apostrophes in those cells:
Change the text format in the range to date format.
with Find & Replace:
Find: .*
Replace: &
In more options: mark selected range and regular expressions.
Select the range if not selected.
Replace All.

edit flag offensive delete link more


Worst hack ever that LibreOffice should fix with an actual interface, but it worked...

PeterAnsell gravatar imagePeterAnsell ( 2016-04-12 08:03:30 +0200 )edit

Also worked for me! Converted '02 Apr 2017 to 02/04/2017 Thank you @m.a.riosv

AndreRicardo gravatar imageAndreRicardo ( 2017-06-01 13:40:03 +0200 )edit

It works, thanks!

alextoind gravatar imagealextoind ( 2017-07-03 18:24:49 +0200 )edit

Question Tools


Asked: 2012-10-02 01:51:55 +0200

Seen: 15,776 times

Last updated: Jan 25 '13