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
Try this, I am sure you will resolve your mentioned problem.
On 07/08/2013 10:56 AM, Harshad Italiya wrote:
I am using LibreOffice Calc 18.104.22.168. 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: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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