Forum Discussion
EXCEL FILE AUTOMATICALLY CONVERTS DATE TO 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
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
- 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.