如何防止从Google表单填充到Excel表格时日期重新格式化?

huangapple go评论64阅读模式
英文:

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().

huangapple
  • 本文由 发表于 2023年5月11日 03:18:11
  • 转载请务必保留本文链接:https://go.coder-hub.com/76221904.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定