![]() |
Inserting dates
If anything appears in cell A1, I want the date to appear in cell B1 but not
upate. I would like that date to remain the same and not change (update). |
Inserting dates
One way: select cell B1
Hit Ctrl+; (Ctrl and semicolon) That will insert today's date HTH -- AP "JDay" a écrit dans le message de news: ... If anything appears in cell A1, I want the date to appear in cell B1 but not upate. I would like that date to remain the same and not change (update). |
Inserting dates
Try this:
=IF(A11,NOW( ),0) It will place the current date in B1. Not sure if that is what you mean by 'Not Change'. Corey.... "JDay" wrote in message ... If anything appears in cell A1, I want the date to appear in cell B1 but not upate. I would like that date to remain the same and not change (update). |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com