| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 35800 | 2003-07-22 03:49:00 | Auto insert static date in Excel 2002 | GregD (3099) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 161916 | 2003-07-22 03:49:00 | Is there a way to auto insert a static date in Excel 02 like you can in Word? Have tried +TODAY() and the date option in header but if it's opened on a future date it shows that date. Need it for a statement date so it has to remain as originally auto-inserted. Hope you can help. Cheers Greg |
GregD (3099) | ||
| 161917 | 2003-07-22 04:10:00 | Hi, there is no autoinsert as such but you can use shortcut keys. Click in the cell you want the date then press the CTRL & ; keys (both keys at once) |
parry (27) | ||
| 1 | |||||