Ask Your Question
0

plain text date to date type [closed]

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

altair gravatar image

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

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

Comments

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 +0100 )edit

3 Answers

Sort by » oldest newest most voted
0

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

JohnSUN gravatar image

Try functions DATEVALUE() and TEXT()

=TEXT(DATEVALUE(A1);"DD.mmm.YYYY")
edit flag offensive delete link more

Comments

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 +0100 )edit
0

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

L-user gravatar image

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

  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
edit flag offensive delete link more
0

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

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

Stats

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

Seen: 229 times

Last updated: Sep 16 '13