Trying to concatenate a letter with a date
Solved/Closed
Hello,
I'm trying to keep a date in a recognisable format and precede it with a character.
e.g. I want "D" and 27 July 2015 to appear as D 27 July 2015.
Each approach I try ends up with the date back in serial number form D40750
Any ideas anyone please?
I'm trying to keep a date in a recognisable format and precede it with a character.
e.g. I want "D" and 27 July 2015 to appear as D 27 July 2015.
Each approach I try ends up with the date back in serial number form D40750
Any ideas anyone please?
Related:
- Trying to concatenate a letter with a date
- How to underscore a letter - Guide
- Special character letter - Guide
- How to put an accent over a letter - Guide
- Capital letters with accents - Guide
- How to change small letter to capital letter in open office - Guide
