Apostrophes around referenced date leading to number instead of formatted date

[sheepdemon]

I'm trying to quote a date from another sheet in my Excel doc, however for <reasons> I need this date to be surrounded by apostrophes. To keep the sheet simple/clean, I'd prefer that these be in the same cell.

If I reference the date cell it copies perfectly fine :

However when I try to surround this in apostrophies it reformats to a number :

Now I know the reason for this (something something days since 1899), however I don't know how to prevent this from happening, if this is even possible. Any assistance appreciated.

 

[RoryA]

You could use:

=TEXT('Enter data here'!E11,"'yyyy/mm/dd'")

 

[sheepdemon]

You could use:

=TEXT('Enter data here'!E11,"'yyyy/mm/dd'")

You are a scholar and a gentleman. Knew it would be something simple. Thanks

 

[RoryA]

Glad we could help.