Home > Net >  How to apply Date format to the Imported Range
How to apply Date format to the Imported Range

Time:01-12

I have a question, how to apply date format to the results comming from query(Importrange) formula.

My formula "=filter({A:A,row(A:A)},isnumber(A:A))" in B1 can't see these dates. Spreadsheet only can see this as a text, not number.

enter image description here

enter image description here

  • Related