Dates showing up as 5 digits, not sure how to change them back to text

Question

Not sure how to revert dates back to text, I looked everywhere but none of the other formulas worked, not sure if this is because of the concatenate/&

https://i.stack.imgur.com/Jv9bc.png

https://i.stack.imgur.com/TsLCp.png

https://i.stack.imgur.com/flJ4Q.png

user_15168872 · Answer

Instead of referring to the date cell directly try this:

=TEXT(E1,"mmm dd, yyyy")

Dates showing up as 5 digits, not sure how to change them back to text

1 Answers