Re: [libreoffice-users] Default Date Format in Libreoffice Calc

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.

Regards

Andrew Brown

On 07/08/2013 10:56 AM, Harshad Italiya wrote:
> Hi,
>
> I am using LibreOffice Calc 3.6.2.2. 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: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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