Report

Trying to concatenate a letter with a date [Solved]

Ask a question GBW - Last answered on Oct 27, 2016 08:16AM
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 
Helpful
+0
moins plus
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.
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!