How to auto insert "/" in sql code or excel?

[MediaStar]

Guys i need some help. As u can see my image 'DODATE' column display date '20130901', '20130902' etc..

Is there any sql script how to make the date auto display like this format '2013/09/01', i need '/' symbol.

Or any function in excel to auto change all data in 'DODATE' column from '2013xxxx' to '2013/xx/xx'?

 

[Moggy]

in mysql i would do it like

 SELECT field1, field2, DATE_FORMAT(STR_TO_DATE(DODATE, '%Y%m%d'), '%Y/%m/%d'), field4 , etc FROM etc......