ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I turn off the Auto Date function in Excel (https://www.excelbanter.com/excel-worksheet-functions/71846-how-do-i-turn-off-auto-date-function-excel.html)

Tim

How do I turn off the Auto Date function in Excel
 
I'm trying to print dated contracts. When I open the document, it uses
today's date instead of the original date it was created.

Steve1154

How do I turn off the Auto Date function in Excel
 

goto the cell holding the formula
TODAY()
and delete it

Steve


--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile: http://www.excelforum.com/member.php...o&userid=31550
View this thread: http://www.excelforum.com/showthread...hreadid=512700



All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com