Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rao Ratan Singh
 
Posts: n/a
Default 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.
  #3   Report Post  
Bob Umlas, Excel MVP
 
Posts: n/a
Default

=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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function Won't Calculate -- Sometimes Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 4 April 13th 05 04:38 PM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"