CODEWITHSUNDEEP
exceldatetextexcel-formula
bf93
bf93

Reputation: 1

Problem to convert date into string in excel

I am facing an issue to convert a date into string in excel using TEXT and TODAY().

When I use the following formula:

="today is " & TEXT(TODAY(); "dd/mm/yyyy")

into a cell I got a value error. When I test with a different formatting:

="today is " & TEXT(TODAY(); "ddmmyyyy")

this time I got "today is dd12yyyy" instead of today is 02122022. I would like to display according the first formatting: "today is 02/12/2022" (For December 2nd 2022).

Upvotes: 0

Views: 43

Answers (1)

Solar Mike
Solar Mike

Reputation: 8375

I suggest you need:

="today is " & TEXT(TODAY(), "dd/mm/yyyy")

I have tested on mine and that works correctly.

If you copied that formula from the web then they may have the ; as their separator, something we have learnt to spot.

enter image description here

Upvotes: 0

Related Questions