hello,
could you please help me out once again.
this time i have the following problem with excel
i need a date to be shown when entering data
eg. A2 i enter a part number and B2,C2,D2 have other information in
i would like cell E2 to automatically show that current date ie(05/10/06)
BUT
when i open the spreadsheet next time i would like 05.10.06 to remain on those lines i entered then and any new lines i enter now i would like the new date to be shown
i tried =NOW() but this only shows the date when i open the spreadsheet
Kind regards
ExcelRoy
could you please help me out once again.
this time i have the following problem with excel
i need a date to be shown when entering data
eg. A2 i enter a part number and B2,C2,D2 have other information in
i would like cell E2 to automatically show that current date ie(05/10/06)
BUT
when i open the spreadsheet next time i would like 05.10.06 to remain on those lines i entered then and any new lines i enter now i would like the new date to be shown
i tried =NOW() but this only shows the date when i open the spreadsheet
Kind regards
ExcelRoy