Thread
:
date fix
View Single Post
#
2
Dave O
Posts: n/a
You can parse this in another cell using MID, RIGHT, and LEFT
functions. Assuming your 20050507 is in cell A1, the formula is
=mid(A1,5,2)&"/"&right(A1,2)&"/"&left(A1,4)
Reply With Quote