Help with date conversion - yyyymmdd to dd/mm/yyyy
 

Please can someone tell me how I can convert a date of format

20051212

to

12/12/2005?

Thanks in advance.


--
markperry
------------------------------------------------------------------------
markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593
View this thread: http://www.excelforum.com/showthread...hreadid=503334

Help with date conversion - yyyymmdd to dd/mm/yyyy
 

Hi markperry

If it`s columns, select columns and change it
on the format, cells meny.

Regards
yngve

Help with date conversion - yyyymmdd to dd/mm/yyyy
 

If it is stored as a text item then assuming data is in cell A1 - in a
suitable cell:

=right(a1,2)&"/"&mid(a1,5,2)&"/"&left(a1,4)

will put it into the order that you want.

"markperry" wrote:


Please can someone tell me how I can convert a date of format

20051212

to

12/12/2005?

Thanks in advance.


--
markperry
------------------------------------------------------------------------
markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593
View this thread: http://www.excelforum.com/showthread...hreadid=503334

Help with date conversion - yyyymmdd to dd/mm/yyyy
 

This works perfectly - much appreciated.


--
markperry
------------------------------------------------------------------------
markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593
View this thread: http://www.excelforum.com/showthread...hreadid=503334