dates in columns on excel

  bbmf474 12:26 13 Mar 2008
Locked

I have crated a large excel spreadsheet where dates are in 3 columns ie day/month/year
Is there a way to get the dates in a single column
thanks in advance
bbmf

  VoG II 12:27 13 Mar 2008

Assuming that day, month and year are numbers in columns A, B and C

=DATE(C1,B1,A1)

  bbmf474 12:38 13 Mar 2008

thanks very much VoG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?