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 ----- IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-MONTH-problem-tp4070686.html Sent from the Users mailing list archive at Nabble.com. -- 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
