Convert date format

Closed
romer - 17 Nov 2009 à 08:06
 fsf - 2 Jun 2010 à 23:58
Hello:

I would like to know how to convert this date format 20091015 (for 2009-10-15) to 10/15/2009. A solution might be to insert a dash between the year-month and between the month-day, however I don't know how to do that. If that were possible, I would be able to format the cells to dd/mm/yyyy.
Related:

2 responses

sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
17 Nov 2009 à 15:46
have a read of this link
http://www.ozgrid.com/forum/showthread.php?t=75930

i think it explains a solution to your problem.