SOLVED

How can i custom this kind of date

Copper Contributor

How can I custom this kind of date in format cells

what do I type in the Type box 

Wednesday, March 14, 2012

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
@Accidentals_genius Try this:
dddd, mmmm dd, yyyy

thank you for your reply but it returned as Wednesday, Jul 27, 2016
can you make the "month" not being short
oh i did it, thank you so much

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution