Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 08-10-2003, 06:30 PM   #1
LQ Newbie
Registered: Aug 2003
Posts: 20

Rep: Reputation: 0
Open Office Sorting by HH:MM:SS DD MMMM YYYY


I'm just getting into LInux. and so far am really impressed. However, I'm finding OPen Office a bit of a pain. I need to sort a spreadsheet by date in the format HH:MM:SS DD MMMM YYYY. In Excel you have shed loads of date formats to choose from but in OO you only have few. I told it to Custom format the cells with HH:MM:SS DD MMMM YYYY format and then tried to sort it but it only sorted it by time and not date.

What can I do?

Thanks TD
Old 08-10-2003, 06:56 PM   #2
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927Reputation: 927
Could you give a sample of the data,
please? I've never seen MMMM in
use before, and wonder what it comes
up with :)

Old 08-10-2003, 07:11 PM   #3
LQ Newbie
Registered: Aug 2003
Posts: 20

Original Poster
Rep: Reputation: 0
Hi Tink, below is a sample of the data. i need to sort by the 1st column. Chers for you help,

"12:07:38 30 June 2003","","Caller rang off"
"10:21:08 29 June 2003","","test"
"12:30:58 25 June 2003","","training"


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Star Office vs. Open Office installation Q viniosity Linux - Software 3 05-21-2006 07:44 AM
Evolution - open word docs with open office (not KWord) bcarl314 Mandriva 1 06-11-2005 10:18 AM
How to Get Open Office 2.0beta to Mimic MS Office 2003 Look? mac57 Linux - Software 2 03-08-2005 08:02 AM
Open Office docs for Microsoft Office btexpress Linux - Software 2 05-17-2004 01:26 PM
Star office / Open Office on Sony Picturebook kkempter Linux - Laptop and Netbook 4 12-11-2003 02:34 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:04 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration