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