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 <d8sconz@gmail.com> 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: users+unsubscribe@global.libreoffice.org 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: users+unsubscribe@global.libreoffice.org 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