change date formats

  1. R

    Date Format Conversion Question

    I regularly download a .csv file which I open in Excel and then save as 97-2004 workbook (.xls). Contained in this .csv file is a column with dates which are formatted as short dates. I can't seem to find a way to convert these to long dates other than changing the format and then manually...
  2. M

    Dynamic Qurey

    I’ve been trying to find a way to change location and date from import web page and wondered if somebody could help please? http://www.realtimetrains.co.uk/search/advanced/RAM/2018/09/26/0000-2359?stp=WVS&show=all&order=wtt The two areas are highlighted in bold and “RAM” I was going to use a...
  3. S

    Need VBA to change date format in text of entire column

    I have text in column A spread out over as much as a few hundred cells. The data contains normal sentences and paragraphs along with occasional dates which will show up in any one of four different formats in general being: M/D/YY, MM/DD/YY, M/D/YYYY and MM,DD,YYYY. What I need to be able to do...

Some videos you may like

This Week's Hot Topics

Top