Ask Your Question

plain text date to date type [closed]

asked 2013-09-16 18:33:01 +0200

altair gravatar image

updated 2013-09-16 18:34:51 +0200

Hello! Please, I have writtten the whole column as dates:

11.02.1995. etc

So, " ' " is missing (apostrophe). It is not data type, it is plain text. Please, how to convert it to data type?

I need to get the form : 11.feb.1995 for the whole column , of course

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-08 21:04:46.666783


Don't really understand the terminology: "is not data type"? What is your LibreOffice version? What is your operating system name and version?

L-user gravatar imageL-user ( 2013-09-16 19:03:04 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-09-16 20:38:13 +0200

JohnSUN gravatar image

Try functions DATEVALUE() and TEXT()

edit flag offensive delete link more


This is the correct answer. Altair, you need to select it! I would upvote but just signed up so don't have enough "karma."

foobarbecue gravatar imagefoobarbecue ( 2014-03-02 23:07:07 +0200 )edit

answered 2013-09-16 19:04:24 +0200

L-user gravatar image

updated 2013-09-16 19:12:16 +0200

  1. Select cells.
  2. Right mouse click and select Format Cells.
  3. Number tab. From Format dialog select the data format you like to have.

    P.S. If you also need to remove apostrophe from cells (I don't really understand your question), then there are multiple options to do this. I suggest to read the following post:
edit flag offensive delete link more

answered 2013-09-16 23:17:40 +0200

horst gravatar image

I think you have a data format. Just right-click on the cells, select Format Cells, goto Number tab and select there Date format and find your format "DD.mmm.YYYY" or if it is not there type it in the Format field.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-16 18:33:01 +0200

Seen: 253 times

Last updated: Sep 16 '13