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
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 15:20:45
![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](/uploads/image/z/1121720-32-0.jpg?t=1.%E5%A6%82%E4%BD%95%E5%9C%A8EXCEL%E4%B8%AD%E8%AE%A9%E6%96%87%E6%9C%AC%E5%92%8C%E5%85%AC%E5%BC%8F%E5%BE%97%E5%87%BA%E7%9A%84%E6%97%A5%E6%9C%9F%E6%97%B6%E9%97%B4%E5%90%8C%E6%97%B6%E5%87%BA%E7%8E%B0%E5%9C%A8%E4%B8%80%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC.2.%E5%A6%82%E4%BD%95%E4%BD%BF%E6%97%A5%E6%9C%9F%E9%9A%8F%E8%A1%A8%E4%B8%AD%E6%95%B0%E6%8D%AE%E5%8F%98%E5%8C%96%E8%80%8C%E5%8F%98%E5%8C%96.use+a+formula+and+format+so+that+the+%E2%80%9CGenerated+on%E2%80%9D+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 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.希望能直接告诉我公式哦(最好是英文版的)~不要复制黏贴一些有的没的.万谢!
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
按照你的理解,在某个单元格内输入或复制以下公式:
="Generated on "&TEXT(NOW(),"dddd,mmmm,yyyy at hh:mm")
就能满足你的需要.
1、“Generated on” 文本和日期时间同时出现在一个单元格
2、表格内任何数据发上变化,时间就会刷新
3、显示格式如你所需.