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

P

papakfl

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.
 
G

Gord Dibben

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 + ;<space>CTRL + SHIFT + ; to enter date and time.

JE has pointed you towards the event code.


Gord Dibben MS Excel MVP
 
P

papakfl

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

JE McGimpsey

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

Also, there's one non-code suggestion.
 
Top