Converting date to text string in Numbers

[AZhappyjack]

How do I convert a date

TODAY()

to a text string in Numbers? I cannot find any text string functions...

I need to concatenate text with the date to get "Today is TODAY()" in a cell...

 

[AZhappyjack]

How do I convert a date

TODAY()

to a text string in Numbers? I cannot find any text string functions...

I need to concatenate text with the date to get "Today is TODAY()" in a cell...

Nevermind... going back to Excel. Numbers has too be the most brain dead application that Apple (or anyone else, for that matter) has ever concocted... it's pure evil.

 

[NoBoMac]

Brute force for TODAY():

"Today is "&MONTH(TODAY())&"/"&DAY(TODAY())&"/"&YEAR(TODAY())

For "Today is 8/7/2023"

"Today is "&NUMTOBASE(MONTH(TODAY()),10,2)&"/"&NUMTOBASE(DAY(TODAY()),10,2)&"/"&NUMTOBASE(YEAR(TODAY()),10,4)

For "Today is 08/07/2023

 

[svenmany]

Does

CONCAT("Today is ", TODAY())

do what you want?

 

[960design]

How do I convert a date

TODAY()

to a text string in Numbers? I cannot find any text string functions...

I need to concatenate text with the date to get "Today is TODAY()" in a cell...

• LEFT(TODAY(),12) = string representation verified by T function in next column
• CONCAT(TODAY()," DAVE")
• TODAY()& " DAVE"

I cannot find any text string functions...

Double click function cell:

Nevermind... going back to Excel. Numbers has too be the most brain dead application that Apple (or anyone else, for that matter) has ever concocted... it's pure evil.

I prefer Numbers to Excel. Have not used Excel in 10 or 15 years.
Although, I am brain dead.