Q:

Google Sheets IMPORTXML with INDEX

I just encountered an odd behavior with IMPORTXML in Google Sheets. When I user the function IMPORTXML, everything seems to work as intended:

But if I want only one field of the array returned from IMPORTXML using INDEX the very first cell seems to be miscalculated:

So it seems like it mistakes 4/10 with 43377. Does anyone know why?

A:

It converts 4/10 into a date.
Please try:
=TO_TEXT(your_formula)

