ExcelBanter - Date Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Format (https://www.excelbanter.com/excel-discussion-misc-queries/262357-date-format.html)

Graham

Date Format

I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

Roger Govier[_8_]

Date Format

Hi Graham

One way
=--(B1&"/"&C1&"/"&A1)
--
Regards
Roger Govier

Graham wrote:
I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

Teethless mama

Date Format

=DATE(A1,MONTH(C1&1),B1)

"Graham" wrote:

I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

Teethless mama

Date Format

Another...

=--(C1&B1&", "&A1)

"Graham" wrote:

I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

Dave Peterson

Date Format

Another one:

=--(B1&C1&A1)

And give the cell with the formula the format you like (dd/mm/yyyy)

Graham wrote:

I have dates shown as:

A B C

2010 5 Mar

I need them to change to 1 cell in the format 05/03/2010

Can anyone help??
ThanKS
Graham

--

Dave Peterson

All times are GMT +1. The time now is 11:49 AM.