date format macro csv

  1. D

    How to maintain dateformat as d/m/yyyy in csv file before copying to another workbook?

    Dear Excel Experts, Currently, I'm using a vba script to copy content in every sheet1 in csv file into the new worksheet tab next to Sheet1 in master workbook. It supposed to compile all csv file content into one master workbook. However, I notice that those dates format will automatically...
  2. F

    date format

    Hi, in csv file I have column, where are date's with diffrent format as below: 02/03/2014 00:10 1/02/2014 7:25:00 7/03/2013 8:30:00 PM I want to set up the same format for all date's. I`m doing something like: With WS LastRow = WS.Cells(WS.Rows.Count, "A").End(xlUp).Row .Range("T" &...
  3. J

    Date format problem when using macro

    Hi, I am having a little trouble using a macro when copying some dates in that it mixes up UK and US date formats. I have a .csv file in which in one column there are some date values in the UK format "dd/mm/yyyy", such as 10/08/2010 for 10th August 2010. Now, when I open this .csv file, and...

Watch MrExcel Video

This Week's Hot Topics

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
Top