usa date

  1. V

    USA Date Time AM & PM convert to UK Time 24hr

    I thought I was pretty good at managing Date formats in Excel but this one has left me stumped. The raw data field in the csv pre import is in the USA format and complicated by being AM/PM too. ,"8/30/2021 7:39:07 AM", ,"8/29/2021 11:28:40 PM", All other columns are simple numeric or text How...
  2. O

    How do I stop excel switching to US dates?

    Hi All, I'm stuck! I need my dates to display as UK dates DD/MM/YYYY. I have a textbox on a userform in which the user inputs a date DD/MM/YYYY. I have formatted the cell that the date get's put into as DD/MM/YYYY. The problem is that the days and months are being swapped around when...

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