date format issue

[Arjen]

Hello readers,

I am trying to set up a reference list in Excel. I created columns with
author, title etcetera. One of the columns is date, in date format.
When I try to concatenate the whole reference into one cell with this
code (with the date in cell G2):

=C2&" "&D2&" "&E2&" "&F2&" "&G2

My date is displaced by an Excel date, i.e. 38360 for 8 jan 2005. How
can I replace the huge number by the actual date?

Thanks a lot,

Arjen

 

[Muhammed Rafeek M]

Try this one:
=C2&" "&D2&" "&E2&" "&F2&" "&TEXT(G2,"dd mmm yyyy")

 

[Arjen]

Great. Thanks!

A

 

[Muhammed Rafeek M]

pls do rate