change 20141106 into 06/11/2014

Is there a way to change a [General] number like 20141106 into a date 06//11/2014

Thanks
JagwarmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
With a formula, assuming that data is in A1:
=TEXT(A1,"0000-00-00")+0
0
 
JagwarmanAuthor Commented:
brilliant Rory, thanks
0
All Courses

From novice to tech pro — start learning today.