输入数据后如何冻结= today()函数 [英] How to freeze the =today() function once data has been entered

问题描述

我想在Excel中的表中使用= TODAY()函数.但是，一旦将数据输入到该表行中，我希望它不再更改日期(有效地捕获该行数据的添加日期).

I would like to use the =TODAY() function in a table in excel. However, once data has been entered into that table row, I would like it never to change dates again (effectively capturing the date the row's data was added).

这将在表中的每一行上使用，因此，当将数据输入到表中的行下方时，将捕获每个日期.

This will be used on every row in the table, so as data is entered into the table down the rows, each date will be captured.

这有可能吗，我该怎么办?

Is this possible, how do I do it?

编辑-pnuts不同于这个问题.我不想使用按钮，而是要使用单元格公式.

EDIT - pnuts it is not the same as this question. I do not want to use a button, rather a cell formula.

推荐答案

而不是输入公式

=TODAY()

触摸 Ctrl + ;

相反.这将在单元格中放置一个冻结"日期.

instead. This will put a "frozen" date in the cell.

这篇关于输入数据后如何冻结= today()函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！