Forum Discussion

Andre0420's avatar
Andre0420
Copper Contributor
May 11, 2024

Date Setting keeps on changing

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

excel

3 Replies

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 14, 2024

        Andre0420 

        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...