Thread: Automatic update of date once, then remains static
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Automatic update of date once, then remains static
Frank

CTRL + ;(semi-colon) to insert a static date.

Forget the copy/paste special.


Gord Dibben MS Excel MVP


On Wed, 4 Oct 2006 15:21:02 -0700, mfdc_frank
wrote:

Help!! need to automatic update cell with current date, then freeze cell from
further updates. thanx in advance.. Frank

Reply With QuoteReply With Quote