| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL
Need to store the Date & Time whenever a value is entered to a cell.
If a value is entered to celle B3 then the current date & time should be saved in C3. I used the following in cell C3 =IF(B3<"", NOW()," " ) But whenever any operation is done in a cell the Date & Time gets the current value which I dont want to happen. Thanks Asoka |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i see the date the last time a cell was changed? | New Users to Excel | |||
| permanent time and date stamp for Excel --- so it cant be changed | Excel Discussion (Misc queries) | |||
| when i enter time in cell it changed, why? | Excel Worksheet Functions | |||
| Pull and store a value on specific date in another cell | Excel Worksheet Functions | |||
| store file saved date in cell | Excel Worksheet Functions | |||
Threaded Mode
