In a formula, copy the value and formatting of another cell
 

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.

In a formula, copy the value and formatting of another cell
 

see

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
papakfl wrote:

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.

In a formula, copy the value and formatting of another cell
 

Either use event code to timestamp a static date/time into the cell(s) or just
hit CTRL + ; to enter a static date.

CTRL + SHIFT + ; to enter the time.

CTRL + ;<spaceCTRL + SHIFT + ; to enter date and time.

JE has pointed you towards the event code.


Gord Dibben MS Excel MVP


On Sat, 28 Apr 2007 15:28:03 -0700, papakfl
wrote:

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.

In a formula, copy the value and formatting of another cell
 

Thank you for your prompt response. Unfortunately, I am insufficiently
technical to implement this code.

"JE McGimpsey" wrote:

see

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
papakfl wrote:

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.

In a formula, copy the value and formatting of another cell
 

There's a link on that page to David McRitchie's excellent tutorial.

Also, there's one non-code suggestion.

In article ,
papakfl wrote:

Thank you for your prompt response. Unfortunately, I am insufficiently
technical to implement this code.