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

date format

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


Joined: 22 May 2007
Posts: 17
Location: INDIA

PostPosted: Wed May 23, 2007 9:33 pm    Post subject: date format Reply with quote

dear all, when we write date as 23.5.2007 in calc it remains it as it is but if date is less than 12 like 12.5.2007 the it changes the date format as 12/05/2007 which is the date format of the cell for both the cases...kindly guide on the above......
Back to top
View user's profile Send private message Send e-mail
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed May 23, 2007 10:27 pm    Post subject: Reply with quote

The result probably depends on the locale setting. If I type 23.5.7, it enters as 23/05/2007 and displays as 23/05/07.
_________________
search forum by month
Back to top
View user's profile Send private message
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Thu May 24, 2007 12:19 am    Post subject: Reply with quote

This is because your locale must be set to a country that uses mm/dd/yyyy, rather than dd/mm/yyyy like you presumably do.

It's appearing as 23.5.2007 because there is no 23rd month.

When you enter 12.5.2007 it is being recognised as December 5th 2007, NOT 12th May 2007.

Locale can be changed at Tools>Options>Language Settings>Languages
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu May 24, 2007 12:20 am    Post subject: Re: date format Reply with quote

kirti_kapur wrote:
dear all, when we write date as 23.5.2007 in calc it remains it as it is but if date is less than 12 like 12.5.2007 the it changes the date format as 12/05/2007 which is the date format of the cell for both the cases...kindly guide on the above......

I believe on your system "23.5.2007" is a text rather than date. Try to do something with this value in some cell:
=ISTEXT(A1) --> TRUE I gues
=A1-10 --> -10 I guess
Format your date-input cells as you like, preferably through cell styles.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Thu May 24, 2007 12:25 am    Post subject: Reply with quote

Villeroy, you're right of course. I originally wrote the same in my reply, but checked before posting and found that the hard formatting automatically applied by Calc was still "Number General", with no prepended apostrophe, whereas the cells Calc interprets as a date have had "DD/MM/YY" applied.

Why doesn't Calc format it "Text" even though it plainly thinks it is text?
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu May 24, 2007 3:14 pm    Post subject: Reply with quote

Because the following posts are of such general interest, I have split them off to a sticky: Formats.
_________________
search forum by month
Back to top
View user's profile Send private message
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