On 2013-08-20 11:20, IGraham wrote:
Hello
Not sure if I'm doing something wrong, if theres a setting I haven't set or
I've found a bug
Libreoffice Calc
Program settings are >>Options>>Language Settings>>Languages
User interface 'English (uk)'
Date acceptance patterns 'D/M/Y;D/M;D-M'
And the problem is
In a cell (CF3) I have the date >> 01/09/2013 which is DD/MM/YYYY
In another cell I have =MONTH(CF3) this cell is formatted as 'date' 'MMM'
and I expect the cell to show 'Sep' it actually shows 'Jan'
So its showing the day as the month and not the month as the month
Any ideas how to fix
Hi.
This works correctly for me (LO 3.6)
If you enter 13/09/2013, just check it shows 13/09/2013.
What is the locale setting on your PC.
Steve
--
To unsubscribe e-mail to: [email protected]
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
