Put that number in E1 and formated it to a date field. Comes up as December 27, 2021 Used this formula ="Monday "&TEXT(DAY(E1),"##") Using a + I get an error since you are adding a number to a string? ="Monday "&E1 seems to give the number value of the date. On 29 Dec 2020 at 9:27, Peter Dutton wrote: To: users@global.libreoffice.org From: Peter Dutton <Look@iPadRing.net> Subject: [libreoffice-users] Date number has 5 digits Date sent: Tue, 29 Dec 2020 09:27:20 -0500
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+unsubscribe@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
+------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mikes@guam.net mailto:msetzerii@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscribe@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