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

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

Guest

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.
 
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
 
Thank you for your prompt response. Unfortunately, I am insufficiently
technical to implement this code.
 
There's a link on that page to David McRitchie's excellent tutorial.

Also, there's one non-code suggestion.
 
You must log in or register to reply here.

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

want to track time while paste value in multiple column of same roe 1
formula finds values in apparently blank cells 1
Return of value when copying a formula 4
Testing a cell value for a specific weekday. 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
Copying a formula to a range 2
static "now" values 5
Is there a one button shortcut for "copy cell above & paste here" 4

Back
Top