+ Reply to Thread
Results 1 to 3 of 3

About =now() function

Hybrid View

  1. #1
    Rao Ratan Singh
    Guest

    About =now() function

    I put =now() function in a cell in my companies invoice. but it does not
    change according to clock displayed in tast bar.

    Can it is possible?

    Thanks for who will help me in advance.

  2. #2
    Don Guillett
    Guest

    Re: About =now() function

    calculation set to automatic.?

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
    news:E4D8A64B-0CF9-4E82-90A8-0B87F8CEAD2A@microsoft.com...
    > I put =now() function in a cell in my companies invoice. but it does not
    > change according to clock displayed in tast bar.
    >
    > Can it is possible?
    >
    > Thanks for who will help me in advance.




  3. #3
    Bob Umlas, Excel MVP
    Guest

    RE: About =now() function

    =NOW is not a timer - it will only update when the worksheet is calculated.
    If you press and HOLD the F9 key down, it'll match the taskbar clock! But
    that's not how it works. If the worksheet is not recalculated, this number
    will not change.
    Bob Umlas
    Excel MVP

    "Rao Ratan Singh" wrote:

    > I put =now() function in a cell in my companies invoice. but it does not
    > change according to clock displayed in tast bar.
    >
    > Can it is possible?
    >
    > Thanks for who will help me in advance.


+ 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