Display dates in long format

foglandia shared this question 4 years ago
Answered

There are lots of questions and answers related to European timing, but I have not been able to find information on converting dates displayed as numbers to dates displayed as text.


Specifically, I would like (in US format) 04/24/1970 to appear as April 24th, 1970.


Or, 04/24: 12:15 pm to appear as April 24th, 12:15 pm.


Thanks in advance,


Debbie

Comments (1)

photo
1

Hi,


I believe this tutorial will be very helpful. You will also have to use conditions to choose the month name from the number.


Best,


Marc