LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


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

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


HI,

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
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,066
Blog Entries: 11

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

Cheers,
Tink
 
Old 08-10-2003, 07:11 PM   #3
toddydog
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,
TD

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


Reply


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


All times are GMT -5. The time now is 10:16 AM.

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