| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to prevent each item date from changing after "TODAY" formula
I wanted to have the date and time automatically appear whenever I entered an
item in my spreadsheet. However, each time I entered a new item, all the dates and times of the previous items changed as well. I want to enter items on different days, but I want to track the previous dates and times of items entered days before. What is happening is that the next day all the dates and times change. Is there a way to prevent this from happening? Marvin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| "NOW" or "TODAY" date function | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
