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

  • 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
    Commented Aug 5, 2022 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 ? Commented Aug 5, 2022 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.
    – Blindspots
    Commented Aug 8, 2022 at 23:34


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.