[Solved] Date format

Discuss the spreadsheet application

[Solved] Date format

Postby tommyleew » Sat May 09, 2020 5:10 pm

I want a cell to return a referenced cell's date with text and displayed in the cell's date format, not the date serial number.
For example I enter 5/9/20 in A3 that is formatted to display it as 05/09/2020. Perfect.
In B5 I enter ="To be sold by "&A3 which returns the text but the date is in serial number format. To be sold by 43960.
The cell date format is specified as 12/31/1999 but does not display that way.
Please help.
Thanks.
Last edited by robleyd on Sun May 10, 2020 2:21 am, edited 1 time in total.
Reason: Tagged [Solved]
OpenOffice 4.1.3 on Windows10
tommyleew
 
Posts: 6
Joined: Sat May 09, 2020 4:57 pm

Re: Date format

Postby FJCC » Sat May 09, 2020 6:02 pm

Try
Code: Select all   Expand viewCollapse view
="To be sold by " & TEXT(A3; "MM/DD/YYYY")
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Date format

Postby tommyleew » Sat May 09, 2020 8:03 pm

Perfect, thank you!
OpenOffice 4.1.3 on Windows10
tommyleew
 
Posts: 6
Joined: Sat May 09, 2020 4:57 pm


Return to Calc

Who is online

Users browsing this forum: Villeroy and 16 guests

cron