Hello,

I have a downloaded Excel file that uses basic TIMEVALUE, DATEVALUE, INDEX/MATCH functions. However in my Excel and ONLY in my Excel, those are not working properly. The formulas only return #VALUE! errors. I’ve tested downloading said file from 2 other computers with the same Excel version (2019) but those are working. 

Here’s a sample:

The format of the dates under Date of Bid are dd/mm/yyyy hh:mm:ss.

Thank you.

​Hello,I have a downloaded Excel file that uses basic TIMEVALUE, DATEVALUE, INDEX/MATCH functions. However in my Excel and ONLY in my Excel, those are not working properly. The formulas only return #VALUE! errors. I’ve tested downloading said file from 2 other computers with the same Excel version (2019) but those are working.  Here’s a sample:The format of the dates under Date of Bid are dd/mm/yyyy hh:mm:ss. Thank you.  Read More

​