Ask Your Question
0

Data Sorting (source data is date format) [closed]

asked 2013-12-23 15:42:31 +0100

Grenjs gravatar image

updated 2015-11-16 18:17:56 +0100

Alex Kemp gravatar image

Hello.

Product: LibreCalc Version: Version: 4.1.3.2 Build ID: 410m0(Build:2)

I am trying to sort data on a column which contains dates. For instance:

Column A Column B

======= =======

24/12/2010 A Fish Called Wanda

29/05/2010 A Good Day to Die Hard

03/04/2013 A Good Year

I can do this using MS Excel simply by selecting the option of "Sort anything that looks like a number, as a number"

I cannot however find a way of doing this using LibreCalc. LibreCalc sorts the data in Column A based on the first 2 characters.

Can anyone help me please?

Thanks.

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-16 18:18:13.460541

1 Answer

Sort by » oldest newest most voted
0

answered 2013-12-23 23:19:02 +0100

m.a.riosv gravatar image

I think there is not option in for this. But you can easily transform the text date in their values with Menu/Data/Text to columns, setting up properly the options.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-12-23 15:42:31 +0100

Seen: 2,394 times

Last updated: Dec 23 '13