Thread: embedded static time & date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default embedded static time & date
For Date - press the CNTRL key and the ; key at the same time

For Time - press the CNTRL key, SHIFT key and the ; key at the same time


If this post helps click Yes
---------------
Jacob Skaria


"james" wrote:

How do I link this to my spreadsheet, it gives the current date and time
Reply With QuoteReply With Quote