Forum Discussion
Solved
EXCEL FILE AUTOMATICALLY CONVERTS DATE TO TEXT
My excel automatically converts dates <01 Sep 2023 00:00:04> into text. How to prevent this?
That's not formatting, that's your OS settings. If you are on Windows when
Win+R
control international
Ok
and here they are.
If it's already here as text, you may select this column, on ribbon Data->Text to Columns->
on first step keep delimiter
on second one tab
on third on select the column, apply Date and DMY
Great help brother! I used Win+R to update and now it is ok!
dr000man , great to know you sorted this out, thank you for the feedback.