At 01:10 20/08/2013 -0700, Graham Lovatt wrote:
Eventually got what I wanted by using =TEXT(CG4,"MMM")
Interestingly, this gives a different result from the formatting option. The results look the same, but mine was a formatted date (which will be right-aligned by default) and this is an actual text string (which will be left-aligned). But any further calculations on these values will differ. And they will sort differently: January dates come before February ones, but "Feb" comes before "Jan".
Horses for courses. Brian Barker -- 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
