![]() ![]() The CSV file will have the proper date format. When you're done and ready to import, Save As and select CSV (comma-separated-values) as the file type. ![]() Use THE EXCEL-TYPE file to make future changes or updates. Make your changes, format all date columns as shown below, then save the file as an Excel spreadsheet. Summary of this page: Excel will respect your date formatting as long as you save the file as an XLSX (Excel file).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |