sheepdemon
New Member
- Joined
- Nov 30, 2022
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
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.
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.