Hi :) The ' over-rides the formatting and sets it as text. Did you type the ' or did it just appear magically? Was there a typo when you set the date format? Regards from Tom :)
--- On Wed, 1/2/12, Johnny Rosenberg <[email protected]> wrote: From: Johnny Rosenberg <[email protected]> Subject: Re: [libreoffice-users] Problems with format in Calc To: [email protected] Date: Wednesday, 1 February, 2012, 22:11 2012/2/1 Jean Milot <[email protected]>: > Hi all, > > I have a date in a cell : 2012-01-02 > I would like to have the day so i change format : Date / NNNN but when i > change the format. > > I have the apparition of " ' " at the beginning of the cell. > > If i remove it it works i obtain the day. > > For now, i use : JOURSEM(date) > > Thanks. NNNN works for me, LibreOffice 3.3.4, Ubuntu 10.10. The cell displays ”onsdag” (Swedish for Wednesday) for today's date (2012-02-01) and ”måndag” (monday) for 2012-01-02. You didn't mention your operating system or version of LibreOffice, maybe there is a bug in your version? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions 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 -- For unsubscribe instructions 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
