How do I insert current date every time I open the file (same)

India
May 12, 2008 5:58am CST
In excel I want everytime when I open one particular file serial number and date should automatically be updated. Is there any procedure in Excel? If so please let me know. Thanks & Regards,
1 response
chiyochan
@chiyosan (30183)
• Philippines
12 May 08
hi there. if you want your file to display the current date just put this formula on one of the cells: =now() it should do the trick for you. :) let me know if it helps. regards!
kunalgaurr
@kunalgaurr (536)
• India
12 May 08
Thanx buddy! But when I open the same file next day. Will it automatically update? ALso I would like to know if I put Number e.g. PO No. - 001 and want to update next time when I make another PO. will it come automatically. Thanx 'n' cheers,