uk to us date format

  1. A

    Mail merge date format selectively ignoring field codes

    Hello all, A colleague has stumped me with this problem. A mail merge involving a UK format date from excel 07 to Word 03 selectively ignores the field codes set in the Word document. The date should be 2nd July 2013, displayed as 02/07/2013, but comes out as 07/02/2013. Now, we are not...
  2. C

    Change Date from UK to US format

    I'm downloading a bank statement from HSBC and need to be able to convert the date from a UK 31/10/11 format to US 10/31/11. If someone has a formula or code that can do this I would be grateful! Thanks in advance! Clint

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