+ Reply to Thread
Results 1 to 3 of 3

Is there a Timestamp function that does not update in Excel?

  1. #1
    Guard 823
    Guest

    Is there a Timestamp function that does not update in Excel?

    Is there a function or a formula that will create a timestamp in a cell
    without it being updated when the spreadsheet is saved? Like a =NOW()
    function that isn't updateable or can you make the =NOW() function where it
    doesn't update?

  2. #2
    Kirchberger
    Guest

    Re: Is there a Timestamp function that does not update in Excel?

    >From Excel Help -

    Insert the current date and time in a cell
    Insert a static date or time

    Current date Select a cell and press CTRL+;
    Current time Select a cell and press CTRL+SHIFT+;

    Current date and time Select a cell and press CTRL+; then SPACE then
    CTRL+SHIFT+;

    Gary


  3. #3
    JE McGimpsey
    Guest

    Re: Is there a Timestamp function that does not update in Excel?

    See

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

    In article <[email protected]>,
    Guard 823 <Guard [email protected]> wrote:

    > Is there a function or a formula that will create a timestamp in a cell
    > without it being updated when the spreadsheet is saved? Like a =NOW()
    > function that isn't updateable or can you make the =NOW() function where it
    > doesn't update?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1