| View previous topic :: View next topic |
| Author |
Message |
kirti_kapur
General User
Joined: 22 May 2007
Posts: 17
Location: INDIA
|
 Posted: Wed May 23, 2007 9:33 pm Post subject: date format |
 |
|
| 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 |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Wed May 23, 2007 10:27 pm Post subject: |
|
|
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 |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Thu May 24, 2007 12:19 am Post subject: |
|
|
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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu May 24, 2007 12:20 am Post subject: Re: date format |
|
|
| 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 http://forum.openoffice.org |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Thu May 24, 2007 12:25 am Post subject: |
|
|
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 |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Thu May 24, 2007 3:14 pm Post subject: |
|
|
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 |
|
|
|
