Forum Discussion
NAGIP
Jan 19, 2021Copper Contributor
Date conversion from Text to DATEVALUE accepted value
In my downloaded Excel sheet, the date value is in MM/DD/CCYY format but my Laptop date format is in DD/MM/CCYY. So the value that has come as January 10th is read as Oct 1st. How can I read the date...
Wyn Hopkins
Jan 20, 2021MVP
Hi
What extension does the downloaded Excel sheet have? Is it .xls or .xlsx?
If .xlsx then best option would likely be to use Power Query to pull in the data from the unopened file.
Have you used Power Query before?
What version of Excel are you using e.g. Excel 365, 2019, 2016 etc
What extension does the downloaded Excel sheet have? Is it .xls or .xlsx?
If .xlsx then best option would likely be to use Power Query to pull in the data from the unopened file.
Have you used Power Query before?
What version of Excel are you using e.g. Excel 365, 2019, 2016 etc