Hi Andrew, Yes now it is resolved as I changed my System time format. Thanks for support.
On Thu, Aug 8, 2013 at 1:23 PM, Andrew Brown <andre...@icon.co.za> wrote: > 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+unsubscr...@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