Best answer

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

  • 23 April 2022
  • 1 reply
  • 76 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?

icon

Best answer by Troy Tessalone 23 April 2022, 03:38

View original

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

Userlevel 7
Badge +14

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