yyyy/mm/dd

  1. G

    Convert Numbers to Date Format

    Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...
  2. S

    Formatting date question ....

    I have data in columns G & H which is 13/11/2019 (ie, 13th November 2019) I want this date to display as 2019/11/13 When I formal cells > custom and enter the format as yyyy/mm/dd, this looks good. I save (as csv) and reopen the file, but it reverts back to it's original formatting? How do I...
  3. R

    Saving as csv

    Hi Excel gurus, Excel csv format when i save my date as yyyy-mm-dd, as text. Then i open the file, it converts into yyyy/mm/dd which is not supposed to be. please advise how to keep the “-“ format. Cheers!
  4. A

    Convert raw input from yyyy/mm/dd to dd/mm/yyyy, not just format

    Hi, I really struggle with manipulating date formats and date input fields sometimes. I've got dates entered as yyyy/mm/dd on a few hundred rows. It's easy to change the format to dd/mm/yyyy but the problem is that the raw input is still yyyy/mm/dd. So it appears excel is getting confused by...
  5. J

    Format data yyyy/mm/dd

    Good Afternoon, I have this columns: <nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr> <nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr><nobr></nobr>...

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