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
It depends on your regional format. If it is like dd/mm/yyyy such datetimes shall be recognized correctly. If months are on first place most probably it'll be considered as text.
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
