How can I convert dates formatted as yymmdd e.g. 051213 to show as 13/12/05.
And vice versa? Any help would be appreciated.

Brian

Assuming the date that you describe has been stored in the cell as a
date, and not just a string of digits you can do the following:

Select the cells that you want to reformat and choose

Format Cells Number Custom, and in the area marked _T_ype
enter dd/mm/yy

If the "dates" are currently stored as strings of digits, do the
following:

Select the column containing the dates and go

Data Text to Columns

Choose Fixed Width

Next Next

Choose Date, and from the drop-down menu pick DMY.

Then do the custom format that I described at top.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=538289

That's great. Thanks CaptainQuattro.

Brian


"CaptainQuattro"
<CaptainQuattro.277wdy_1146636000.8966@excelforu m-nospam.com wrote in
message news:CaptainQuattro.277wdy_1146636000.8966@excelfo rum-nospam.com...

Assuming the date that you describe has been stored in the cell as a
date, and not just a string of digits you can do the following:

Select the cells that you want to reformat and choose

Format Cells Number Custom, and in the area marked _T_ype
enter dd/mm/yy

If the "dates" are currently stored as strings of digits, do the
following:

Select the column containing the dates and go

Data Text to Columns

Choose Fixed Width

Next Next

Choose Date, and from the drop-down menu pick DMY.

Then do the custom format that I described at top.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=538289