Plain text date to date type

[altair]

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

[L-user]

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]

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: http://en.libreofficeforum.org/node/484

[JohnSUN]

Try functions DATEVALUE() and TEXT()

=TEXT(DATEVALUE(A1);"DD.mmm.YYYY")

[foobarbecue]

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

[horst]

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.