Skip to main content
Answer

My Google Sheets output values do not match my input values

  • July 24, 2022
  • 2 replies
  • 146 views

Howdy! I’ve been having trouble with google sheets not formatting my dates correctly. It has a correct input value, but the output value does not match the input. All other columns are formatted correctly in the output, it is just the one with the date. What else is weird is that I have another branch to update a row, and when I update the date there, it formats it correctly. In both branches, the data is gotten from the same variable. What is happening here, and is there a way to get around this? 

 

Best answer by rattzombie

I see what the issue is now! Google sheets is formatting the date as a number instead of a date. I needed to go to format and change the cell to format as a date instead of a number. I found the solution here.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

  • Author
  • Beginner
  • Answer
  • July 24, 2022

I see what the issue is now! Google sheets is formatting the date as a number instead of a date. I needed to go to format and change the cell to format as a date instead of a number. I found the solution here.


jesse
Forum|alt.badge.img+9
  • Architect
  • July 25, 2022

Hey @rattzombie so glad you were able to find a solution to the issue you were experiencing! And thanks for coming back to this thread to share it with others as well. 🙂