1/1/1900

  1. B

    trying to change dd/mm/yy to mm/dd/yy

    <tbody> Dates Text to Columns Text to Columns Text to Columns Search "/" 23/11/2018 23 11 2018 3 1/3/2019 1/1/1900 3 2019 <tbody> #VALUE! </tbody> 31/03/2019 31 3 2019 3 1/11/2018 1/1/1900 11 2018 #VALUE! 24/10/2018 24 10 2018 3 </tbody> The first...
  2. D

    Report Generated Data to a Usable Table

    Hi Everyone, I have a report generated from another program. It's giving me all of the information I need, it just not in a usable table form. I will try to explain. This is what a single employee record looks like. <tbody> A B C D E F G H 1 Name: John Doe 2 Employee ID: 1234...

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