The correct format of your date of birth should be in dd/mm/yyyy. Sometimes, you can fix the dates by copying a blank cell, then selecting the date cells, and using Paste Special > Add to change them to real dates. Why is the date format not working in Excel?įix the Dates If you want to sort the dates, or change their format, you’ll have to convert them to numbers – that’s how Excel stores valid dates. You can disable/re-enable the Save As box by going to File–>Options–>Save–>’Show data loss warning when editing comma delimited files’. You can ensure Excel helps prevent formatting loss with its automatic Save As dialogue box. Why does csv file not save formatting?ĬSV files contain only data. Now all dates are converted to texts and shown as yyyy-mm-dd format. I1, and type this formula =TEXT(G1, “yyyy-mm-dd”), and press Enter key, then drag AutoFill handle over the cells needed this formula. Ignore that and click “Continue”.Ĭonvert date to yyyy-mm-dd format with formula Select a blank cell next to your date, for instance.
How to enter YYYY-MM-DD HH-SS in Excel?.How do I format a date in YYYY-MM-DD in SQL?.What is MM DD format for date of birth?.Why is the date format not working in Excel?.How do I keep formatting in a csv file?.