Forum Discussion
Date Time format not sticking
The formula bar will always display a date using the Short Date format of your system, regardless of how the cell is formatted.
The way the cell is displayed depends on the number format.
If you want to export to a text file in a specific format, it may be best to create an extra column with formulas of the form
=TEXT(date_cell, "desired format")
For example:
=TEXT(D2, "dd/mm/yyyy")
Use the column with the formulas in the export.
The formula bar will always display a date using the Short Date format of your system, regardless of how the cell is formatted.
The way the cell is displayed depends on the number format.
If you want to export to a text file in a specific format, it may be best to create an extra column with formulas of the form
=TEXT(date_cell, "desired format")
For example:
=TEXT(D2, "dd/mm/yyyy")
Use the column with the formulas in the export.