Copy System Time

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

Guest

Hello,

Is there any formula that can be use to copy system time? As i know we can
use =NOW() to get the system time but it will change when we close and open
again. I need some formula to copy from =NOW() and not change when we close
and open again.

Thank you
 
By definition any formula will recalculate (unless recalculation is turned
off, of course...), so to "freeze" a cell you must have a value in it. The
simplest way in your case is to type =now() and then press F9 which does an
in-cell calculation and replace a formula (or the highlighted part of a
formula) by its value.
 
CTRL + SHIFT + ; will enter a static time in a cell.


Gord Dibben MS Excel MVP
 
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

Excel Help to copy information from one row at a time to another sheet 1
Excel Sequential Numbering System 0
Copy and paste special 2
Formulas not calculating periodically 4
File won't open 1
Transfer or copy album structure (not just photos) from iPhone 14 to PC 3
Time in Excel 5
using formulas from other workbooks 2

Back
Top