Thread: date fix
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

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)