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

Short of writing code, you could enter your numerics only date in cell
A1, for instance: 07142005. Then in B1 write a formula:
=mid(A1,1,2)&"/"&mid(A1,3,2)&"/"&left(A1,4)

Then you could copy column B and paste as values into their required
spot.