Static Date
 

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

Static Date
 

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

--
Regards

Roger Govier


"Jesse" wrote in message
...
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