Hi :) As a purely cosmetic change how about TEXT (Xn:"NN DD MM YYYY") I am not sure what the NN is doing tbh, but it's probably crucial. I am not sure this will work because it might be a case of a hard-coded specific answer rather than something that can be edited.
DD usually gives 2 figures for the day (ie 02 or 03 but still 11, 12 etc) rather than just D which gives a single digit for under 10 (ie 2, 3 etc). MMM spells out the month, ie June, July etc but MM should just give 2 digits such as 06, 07 etc. If it's possible to have a space between the Ms and the Ys that might make it tidier. Regards from Tom :) On 6 September 2014 10:55, Ross <[email protected]> wrote: > Thanks Brian - you were right and you were right!! TEXT(Xn;"NN D MMMYY") > took care of the formatting. And the result looked bloody awful. Back to > the > drawing board. > > > > -- > View this message in context: > http://nabble.documentfoundation.org/dateValue-to-dateText-tp4121333p4121362.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 > > -- 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
