date format issue
 

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

date format issue
 

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

"Arjen" wrote:

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

date format issue
 

Great. Thanks!

A

date format issue
 

pls do rate

"Arjen" wrote:

Great. Thanks!

A