Skip to main content
Best answer

How do I format dates and phone numbers from a Google Form to a Google Sheet?

  • April 23, 2022
  • 1 reply
  • 420 views

I am trying to get information from one spreadsheet (that’s automatically completed as google forms responses come in but we hate the format). i.e. the date/time stamp when a simple 4/22 is what we are looking for. I can format the initial sheet but it doesn’t stay formatted for new forms responses. Is there a way to format the zap to change the date and phone number formats that come in a different way?

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @iceicebaby82 

Good question.

Check out the Formatter app.

Help articles:

https://zapier.com/help/create/format/modify-number-formats-in-zaps

https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31416 replies
  • Answer
  • April 23, 2022