早教吧作业答案频道 -->其他-->
1.如何在EXCEL中让文本和公式得出的日期时间同时出现在一个单元格.2.如何使日期随表中数据变化而变化.use a formula and format so that the “Generated on” text appears as in the Sample Report but the date and tim
题目详情
1.如何在EXCEL中让文本和公式得出的日期时间同时出现在一个单元格.2.如何使日期随表中数据变化而变化.
use a formula and format so that the “Generated on” text appears as in the Sample Report but the date and time shown recalculate when the spreadsheet refreshes.在网上看到过我的第二问的解法.但是都是VB什么的.不知道有没有单纯的公式解法,还是我对题目的理解有误?例子是一个格子里面显示：Generated on Thursday,January,2010 at 15:16.希望能直接告诉我公式哦（最好是英文版的）~不要复制黏贴一些有的没的.万谢!
use a formula and format so that the “Generated on” text appears as in the Sample Report but the date and time shown recalculate when the spreadsheet refreshes.在网上看到过我的第二问的解法.但是都是VB什么的.不知道有没有单纯的公式解法,还是我对题目的理解有误?例子是一个格子里面显示：Generated on Thursday,January,2010 at 15:16.希望能直接告诉我公式哦（最好是英文版的）~不要复制黏贴一些有的没的.万谢!
▼优质解答
答案和解析
按照你的理解,在某个单元格内输入或复制以下公式：
="Generated on "&TEXT(NOW(),"dddd,mmmm,yyyy at hh:mm")
就能满足你的需要.
1、“Generated on” 文本和日期时间同时出现在一个单元格
2、表格内任何数据发上变化,时间就会刷新
3、显示格式如你所需.
="Generated on "&TEXT(NOW(),"dddd,mmmm,yyyy at hh:mm")
就能满足你的需要.
1、“Generated on” 文本和日期时间同时出现在一个单元格
2、表格内任何数据发上变化,时间就会刷新
3、显示格式如你所需.
看了 1.如何在EXCEL中让文本...的网友还看了以下：
which quadrant represents the line that passer th 2020-05-13 …
1.如何在EXCEL中让文本和公式得出的日期时间同时出现在一个单元格.2.如何使日期随表中数据变化 2020-05-16 …
改被动,The teacher made Peter copy the text 1The tea 2020-05-17 …
谁帮我写下英语作文作业,按以下题目写.Imagine that you were a specta 2020-05-17 …
60 What can we learn from the text?A. The communit 2020-05-24 …
Which of the following is true according to the te 2020-05-24 …
Which sentence in the text is the closest in meani 2020-05-24 …
It can be inferred from the text that the author . 2020-05-24 …
Which is true about the warship patro ls according 2020-05-25 …
We can learn from the text that the wheels of the 2020-05-25 …