英文:
How do I prevent the date from reformatting when new data populate into an excel sheet from Google form?
问题
I want to have the dates of new responses format like this: May 10.
我想要新回复的日期格式为:5月10日。
英文:
I have created a Google form and used an excel sheet to populate data that are entered into the form. When there is a new submission, the date formatting reverts to this: 5/10/2023 14:54:39. I want to have the dates of new responses format like this: May 10.
Sheet can be viewed here: https://docs.google.com/spreadsheets/d/1B-dP6GZqec7ONuXa89LRBNt-rnnHg18d7ihQXGKEIxU/
I'm still learning excel and have tried using an "ARRAYFORMULA" but I keep getting errors because I have just copy and pasted formulas I found online. Because I don't exactly understand what the formulas mean, I'm not sure how to adjust it specifically for my sheet.
答案1
得分: 1
将时间戳复制并以您指定的格式显示,请将此公式放在一个空列的第1行:
=query(A1:A, "format A 'MMM d'", 1)
查看 query()。
英文:
To copy the timestamps and show them in the format you specified, put this formula in row 1 of a free column:
=query(A1:A, "format A 'MMM d' ", 1)
See query().
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论