View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Billy B Billy B is offline
external usenet poster
 
Posts: 54
Default Converting text to yy/mm

I have a regular data that I import. Data that is input to column F comes in
as formatted as text with quotes around it ( i.e. "0601"). (If it helps, the
column to the right of this data is blank.) I have no control over the
imported formatting so it needs to be converted. This data should be
formatted as a date with yy/dd format. The resulting date from the initial
data would be 06/01 I need all the help I can get developing a macro that
will accomplish this.