Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi Harshad

I find this in my support of clients, a common issue with spreadsheets. Not sure whether you are using a Windows based system or Linux based, but the fix is the same. Start off first with making sure your base operating system is regionalized correctly for your country / language etc. Windows is more the culprit for doing this, and sets defaults for American English, but you could have it wrong for your Linux as well.

If you correct it within the country/language settings (Windows - Control panel - Region and language)(Ubuntu Linux and other similiar distros - System Settings - Language Support - Languages)||, then your spreadsheet (and all other data for that matter) will tend to default to your global settings. You will see a section where you can correct the default date format. My country and language settings is the same as yours, date then month then year,and I have to correct mine this way as well.

Try this, I am sure you will resolve your mentioned problem.


Andrew Brown

On 07/08/2013 10:56 AM, Harshad Italiya wrote:

I am using LibreOffice Calc When I enter Date as 30/05/2013 in
column it displays it according to the format I have selected for CELL. Now
when I go for edit this column I can see it is changing this DD/MM/YYYY
format in which I have entered data to MM/DD/YYYY automatically.

Is there any way so I can set DD/MM/YYYY default so whenever I go for
editing it will show me 30/05/2013 not 05/30/2013 ?

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.