View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JasonK[_3_] JasonK[_3_] is offline
external usenet poster
 
Posts: 38
Default formula to place real time in a cell when data entered in an adjacent cell


Still using 2003.

I have a spread sheet that records data in a column that is entered by
the user. I need a cell next to the entered data cell to reflect the
accurate date and time the data was entered.

Is there a formula I can enter into the adjacent cell that will
automatically place the instant date/time that will not update with
the next data entry?

Thanks in advance,
JasonK