View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default How to separate numbers from text??

And totally by the way, you can convert the datestamp (assuming it
means (in this example) 12/20/2005) to an Excel readable date with this
formula:
=DATEVALUE(MID(A1,1,2)&"/"&MID(A1,3,2)&"/"&MID(A1,5,2))
.... and format the results as a date.