us date

  1. C

    Issue with UK & USA Date Format

    Is there a formula that I could use to convert US dates to UK dates. To explain a bit further , I have date in cells some with US dates and some with UK dates. What I would like to do is to leave the UK dates as they are and have the UK dates converted. Otherwise I would end up with a blanket...
  2. E

    Multiple csv file import into Excel 2010. US Date issue

    Hello All, Thank you for letting me join the community, I'm pretty new to building VBA script and am attempting to import a folder of 130 odd csv files in to an workbook and then with a second macro combine them into a single worksheet. The below code is what I am using to bring them into the...
  3. T

    Dates converting to US format

    Hi, I have a date format/time of '15/06/200919:17:15' extracted from another system. I usually drop the time using the following macro (which has worked in the past): x = 1 Do Until x = 150 x = x + 1 Dim chngdte1 Range("p" & x).Select chngdte1 = ActiveCell.FormulaR1C1...

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