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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Static Date Insertion Formula 4
Changing dates automatically with the computer date 2
Date and amount of last payment 3
fill in date into adjacent cell automatically 2
IF...payment rates 3
automation 4
Excel How to get the number of days an item was opened from the today's date. 14
Summing like data 5

Back
Top