2 digit year not working in CSV format

Highlighted
Occasional Visitor

Hi all,

In control panel, my date format is dd-mm-yy with default 2 digit year limits (1930-2029). I need to save an excel file in .csv format but it has dates above 2029. I tried to increase the range (1951-2050) however this applies only on the xlsm format and not when i save it as CSV (example: 21-05-40 in CSV is still considered 1940 but in xlsm it is 2040). I do not know what am i doing wrong, most answers online suggest increasing the 2 digit year limit which i have done already with no success.

How can i fix this?

0 Replies