I want to know about know something.
Suppose I have a workbook where lots of date to be input. The date format is like dd/mm/yyyy.
I have to type "/" every separation of day month and year.
Now the thing is, supposed I type 02092021 its automatically converts into 02/09/2021.
also, select which column converts automatically as date, otherwise, all number converts as a date make my workbook invalid .
Is it possible to convert a string as a date?
Thanks in advance.