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: [email protected]
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
