change date formats

  1. L

    Why there is no direct way to change date formats in Power Query?

    Hi everyone here! I am not asking your help for any technical help on any specific data set, right now. Just asking a question I am living with. I respect Power Query for it's obvious automation capabilities. But as an Excel user, sometimes I used to think why this tool lacks some capabilities...
  2. 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...
  3. 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...
    • mikey141
    • Thread
    • change change date formats dynamic qurey excel 2016 website
    • Replies: 1
    • Forum: Excel Questions
  4. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top