I am using importrange and for some cells google sheets changes the format of only a couple cells. I have attached a screenshot. The original worksheet has the correct dates M/DD/YYYY. So I am wondering why only 5-7 cells have a different formatting out of over 1000 rows?

Date format

New contributor
Nicky is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 2
    Check the formatting of those 7 cells, you will notice that it is different from the others ... it does not depend on the formula
    – Daniele
    Aug 5 at 10:07
  • 1
    There is no way for us to be certain of what is happening with the provided information. What is cell formatting in the source sheet and the destination sheet? What are the values shown in the formula bar for the source cells ?
    – Rubén
    Aug 5 at 21:53
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. 2 days ago


Your Answer

Nicky is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.