Ask Your Question

Calc Conversion TEXT to DATE [closed]

asked 2017-02-07 20:13:53 +0200 gravatar image

I am retrieving data from an offsite system. I have no control over the formatting of the data.

I get a DATE, but it is formatted as TEXT. I just simply tried to change the format from TEXT to DATE (mm/dd/yyyy) and I end up with a single quote in from of the date in the cell. I could edit this out, but I have far too many retrieved files.

Is there a way to make the conversion from TEXT to DATE?

Thanks, Rich Ramik

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by
close date 2017-02-16 03:02:22.456753

2 Answers

Sort by » oldest newest most voted

answered 2017-02-07 20:43:17 +0200

JohnSUN gravatar image

Try this trick:


edit flag offensive delete link more


Very clever. I sew what is happening and understand as well.

Thanks very much, Rich Ramik gravatar ( 2017-02-16 02:58:41 +0200 )edit

Cool video. For those who are in a hurry, the short version is: Select column, menu Data->Text to Columns, in the Text to Columns window select column again, then under "Fields:" select the correct Column type.

Albert25 gravatar imageAlbert25 ( 2019-09-08 14:45:47 +0200 )edit

answered 2017-02-08 14:49:45 +0200

karolus gravatar image


Meanwhile importing this datafiles there's very propably a dialog similar to that shown by @JohnSUN.
At this stage you should be able to choose also the same column-type

edit flag offensive delete link more


I know what you are suggesting. I'll have look more closely the next time I have to retrieve data.

Thanks very much, Rich Ramik gravatar ( 2017-02-16 03:00:48 +0200 )edit

Question Tools



Asked: 2017-02-07 20:13:53 +0200

Seen: 27,591 times

Last updated: Feb 08 '17