Convert date format

[Closed]
Report
-
 fsf -
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.

2 replies

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
have a read of this link
http://www.ozgrid.com/forum/showthread.php?t=75930

i think it explains a solution to your problem.