输入数据后如何冻结 =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屋！