Please find me easy way convert date string into data

I need an easy way to convert csv-like or web string into calc data for chart creation.

If this do not exist yet, make report as a bug.

Thanks, ROSt52. I have to specify my needs.

I have no access to an ebay store and grabbed info from their online sales history like following link:

I grabbed all these private listing – buyers’ identities protected AU $7.97 1 06-Mar-14 14:36:38 AEDST
and needed quantity, date and time as elements to analyze sales. Then I shall create a chart for as a proof that this sells well and more budget is needed. Its ok to say about relevant&inrelevant information here. ^.^

You can use the functions DATEVALUE and TIMEVALUE. DATEVALUE ignores time information and TIMEVALUE ignores date information, so you may have to add them together to get a specific point in time.

For example: =DATEVALUE(“2014-05-03”)

Normally, if you paste in a time or date string that Calc understands, it is automatically converted into a number and formatted as a time or date. The above mentioned functions don’t cause this automatic formatting so you may want to select the appropriate number format for the cell.

The underlying format for times and dates is a floating-point number. The integer part is the date and the fractional part is the time. If you want to convert such a number into a string in Calc, use the function TEXT,

For example: =TEXT(A1; “YYYY-MM-DD”)

Hi @jiero, selecting the column type to D-M-Y for the column of dates, in the import windows, works for me.
(I did it pasting as unformatted text, copying directly from web page)

Thank you, this reminds me what i used to do with csv generated by ebay, why I forgot it? Maybe because this isn’t my data, I don’t have access to csv, which lead to my attempt doing the same but ingoring import function. Anyway, I shall try import.

@jiero - What kind of data do you have and what kind of data do you need and what kind of charts do you need?

Please post only answers as answers. If you want to ask something from the asker, do so in comments. This way we know which questions have been answered. :slight_smile:

All you need to do is highlight the area and then Format > Clear Direct Formatting.


Find myself the way, work like import but more flexible - select column and proceed "Menu Entry Data → Text to Columns… " and do same as in import window