View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Display Current Date & Time in a cell: Everytime I open theworkbo

Put

=NOW()

in a cell, and use a custom format on that cell to show date and time
in the style that you wish.

Hope this helps.

Pete

On Sep 2, 10:49*pm, sam wrote:
Hi All,

Is there a way I can display Current Date & Time in a cell which updates
everytime I open the workbook?

Thanks in Advance