Date Setting keeps on changing

Copper Contributor

Hello, Folks!


i have been working on a tracker and it was all well until i have noticed my data skewed because of the changing date setting. it has been set to MDY even on the Text to column function, it was set to MDY (this changes to DMY every time i exit the table.  i have attached several screenshots and the last screenshot Date 5) shows the date format that comes out when i again readjust the Text to Columns setup for date

3 Replies


What is the Short Date system setting on your computer?

@Hans Vogelaar ddmmmyyyy


If your system date setting is in DMY order, the setting in Text to Columns should also be DMY by default.

The formula bar in the last picture shows 4 01 2024. That suggests that the date separator is a space instead of the usual / or -. Perhaps that causes the problem...