In cell A4 is the following code;
="Monday "+January.$A5 January.$A5 has the number 27 in it (December 27) What appears in cell A4 as a result is- Monday 44557 What is needed is- Monday 27 I've tried reformatting cell A4 to a date or text or a number to no success. Any idea how to fix this? Thanks, Peter -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy