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: [email protected] From: Peter Dutton <[email protected]> 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: [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 +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- 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
