Trying to concatenate a letter with a date [Solved/Closed]

GBW - Oct 27, 2016 at 07:19 AM - Latest reply:  GBW
- Oct 27, 2016 at 08:16 AM
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?



See more 

1 reply

0
Helpful
Sorry to trouble you with a trivial problem! A38 ="D".

Answer =A38&" "&TEXT(A48,"dd/mm/yy")

Don't know why I couldn't find it.