Visit Jeremy's Blog.
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 09-04-2008, 02:49 PM   #1
Registered: Nov 2005
Location: Deerfield MA
Distribution: OpenSuSE, Kubuntu
Posts: 293

Rep: Reputation: 41
Changing the default date format for Open

Is there a way to change the default format for dates in I would have thought there would be, but I can't find any way of doing it. I have no trouble changing the format of a date once I've inserted it, however.
Old 09-04-2008, 03:51 PM   #2
LQ Guru
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,249
Blog Entries: 5

Rep: Reputation: 191Reputation: 191
you could modify the style of the default template changing the date format to what you want to use..

For Calc

Ctrl+F11 -> Select Default -> Click on Modify -> Select Numbers Tab -> Select Data - Select Date Format

For Writer

To change the date format do Ctrl+F2 > Document tab > Type=Date > Select=your choice > Format=December 31, 1999.

You should be able to save templates with those settings so they will stick..

Last edited by farslayer; 09-04-2008 at 03:55 PM.
1 members found this post helpful.
Old 09-04-2008, 05:56 PM   #3
Registered: Nov 2005
Location: Deerfield MA
Distribution: OpenSuSE, Kubuntu
Posts: 293

Original Poster
Rep: Reputation: 41
This is for Writer

I would like to change the default date format in openorg.writer, the word processing application.
Old 05-12-2010, 03:33 PM   #4
LQ Newbie
Registered: May 2010
Posts: 1

Rep: Reputation: 0
Correct Default Date

I finally figured out how to do this and am going through and posting the solution to the threads I've been reading for help:

1) in spreadsheet press Ctrl F11
2) Default - Modify
3) Date
4) change the language until you find one that defaults to the format you like (you CANNOT specify your own format) I like Uyghur and Zulu
5) click OK - OK
6) File - Templates - Save
7) File - Templates - Organize
8) right click the saved template and "Set As Default Template"

When a date is entered, it will now be recognized from the correct format and will be rendered in the correct format.
Old 05-13-2010, 09:01 AM   #5
LQ Newbie
Registered: May 2010
Posts: 2

Rep: Reputation: 1
Hello, everyone - after pulling my hair out for a while on this one a few weeks ago when making the switch from WordPerfect (on Windows) to OpenOffice (for both Linux and Windows), I had a flash of inspiration this morning and thought I'd pass it along.
I'm sure the above solution works perfectly, that is, to change the default template. But I'm used in WordPerfect to being able just to hit CTRL + D and have the date come up in my preferred format, which is "May 13, 2010, Thursday", and really like the keyboard shortcut option. In OpenOffice, it didn't seem possible to have a keyboard shortcut to pull this off. Then I realized:

1) Insert --> Fields --> Date
2) Right-click on field, select "Field"
3) Changed the format to my preferred format (Type = Date; Select = Date (fixed); Format = Additional Formats, then, for me, in the format code field, "MMMM DD, YYYY, NNN". Then click "Ok," then "Ok.")
4) Now, select the entire field, then Edit --> Autotext
5) In the Name field, I call this "Today," with the shortcut "t". Then on the right-hand side of the dialog box, select "Autotext," then "New."

The Autotext field reads the current date and uses it; I verified this by changing the computer's date and the autotext gave me the date I'd changed the computer to.

So viola! Now whenever I want that date format to appear, I click "t + F3," and there it is. Hope this helps somebody.
1 members found this post helpful.
Old 09-09-2010, 09:03 PM   #6
LQ Newbie
Registered: Apr 2009
Location: Orlando, FL
Distribution: Ubuntu 8.04 - Hardy Heron
Posts: 1

Rep: Reputation: 0
It helped me. thank you!
Old 09-26-2010, 09:05 PM   #7
LQ Newbie
Registered: May 2010
Posts: 2

Rep: Reputation: 1
Awesome! Glad to hear it!



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
changing default office format of openoffice to ms office compatible format silencer07 Linux - Software 1 08-09-2008 07:53 AM
date shortcut in open office alan_h404 Linux - Desktop 0 10-18-2006 04:07 PM
How do I set default Currency , Date format anilbh Fedora 3 07-05-2006 09:35 PM
Changing System Date Format to DD/MM/YY On RHEL3? krishvij Linux - Newbie 2 03-16-2005 06:58 AM
Changing date format in MySQL table vous Linux - Software 8 09-03-2003 06:30 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:03 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