Hi I am trying to convert Thursday, January 3, 1970 from one cell to the next showing 03/01/1970, or be able to replace the original cell with this date formatting. I am trying to extract data off a website but its going to be loads so will take me hours of flicking keys that would drive me insane. their are a number of different dates and months so it would have to recognised the month year day (3) and discard Saturday or put it into a different cell because would be good to see relationships on the days of the week. would really appropriate your help with this.