We have some data in excel which are percentage data like 23%. But when we are reading the data from excel with Read Range and Preserve Format is not checked then its changing to 0.23. With Preserve Format checked its reading correctly.
But the same code when reads date value, 4/2/2021 12:00:00 AM changes to 59/02/21. But when Preserve Format is not checked it reads the correct value.
So how to correctly read both type of data with the same code ?