0

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

Improve this question
3
  • 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, 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 ?
    – Rubén ♦
    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.
    – Blind Spots ♦
    Aug 8, 2022 at 23:34

0

Reset to default

Your Answer

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