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


Wolfgang Kluge wrote:

Good evening.

Is there any possibility to get the date format in spreadsheets
synchronized?
My operating system ( Linux and  also Windows ) is set to yyyy-mm-dd
The spreadsheet cells must for everey new sheet best to this format.
And still the entry field above the cell - plane shows quite ambigous as
nn/nn/nn which for
backdated entries might look like 03/04/05

Thanks
Wolfgang Kluge





Hi Wolfgang,

Perhaps this will help?

To enter a date in a cell, use the Gregorian calendar format. For example, in 
a (British) English locale, enter 01/02/2002 for 2nd Jan 2002.
All date formats are dependent on the locale that is set in Tools - Options - 
Language settings - Languages.

For example, if your locale is set to 'Japanese', then the Gengou calendar is 
used.

The default date format in LibreOffice uses the Gregorian Calendar.

Best regards

Dave


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Context


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.