Static Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How I can put static date by using any formula in excel. For ex. In Sheet 1 i
have entered payment is paid. I want to record on sheet 2 the date and time
automatical when it is paid.I used Now() function,but it changes whenever i
open my sheet. I want to use it like a Stamp.thanks
 
Hi Jesse

Type Ctrl + ; (that's Control + semicolon) in a cell inserts current
Date as a fixed value.
Ctrl + Shift + ; (that's Control + colon) in a cell inserts the Time
 
Back
Top