OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Default date NOT ISO

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
lcbacon
Newbie
Newbie


Joined: 19 Sep 2006
Posts: 1

PostPosted: Tue Sep 19, 2006 3:22 pm    Post subject: Default date NOT ISO Reply with quote

I type in "2006-09-19"

IT COMES BACK AS "09/19/06"!

If i had wanted "09/19/06" I WOULD HAVE TYPED IT THAT WAY IN THE FIRST PLACE!

+ it's a stupid, dumb format: inside out significance, not even backward, like European.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Tue Sep 19, 2006 11:31 pm    Post subject: Reply with quote

It's so frustrating when developers don't take account of one's personal expectations. Evil or Very Mad

AFAIK, the only way to change the default date format is to change the locale.

What I've done is create a style called _Date as a child of the default format (F11, right-click Default, choose "New"). I've attached the style to the keyboard combination Ctrl+D (Tools >Customise : Keyboard).

You will assuage your frustration somewhat if you do something along those lines.
_________________
search forum by month
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Wed Sep 20, 2006 12:28 am    Post subject: Reply with quote

Icbacon,

have a look at my macro: ins_date/ins_time

Insert date or time, as text / string or field / value, in Writer / Calc, formatted to user needs ( ISO8601 format, adjustable).

Four macros in document's attached BASIC module, usable for keyboard shortcut or customized toolbar assignment.

HTH
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group