Ask Your Question
0

Calc Conversion TEXT to DATE [closed]

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

richramik@yahoo.com 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 richramik@yahoo.com
close date 2017-02-16 03:02:22.456753

2 Answers

Sort by » oldest newest most voted
2

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

JohnSUN gravatar image

Try this trick:

TEXT to DATE

edit flag offensive delete link more

Comments

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

Thanks very much, Rich Ramik

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2017-02-16 02:58:41 +0200 )edit
0

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

karolus gravatar image

Hallo

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

Comments

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

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2017-02-16 03:00:48 +0200 )edit

Question Tools

2 followers

Stats

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

Seen: 15,029 times

Last updated: Feb 08 '17