Forum Discussion
Date Time format not sticking
Hello,
I am trying to format a column in a sheet that is frequently updated by people from all over. The Issue is with the Date column in the formula bar the date will be 30/06/2024 and in the cell it will say 30.06.2024. This really messes up when I am trying to export the data. Does anyone know why the formatting keeps breaking?
TIA
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.
1 Reply
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.