Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
calculation set to automatic.?
-- Don Guillett SalesAid Software "Rao Ratan Singh" wrote in message ... 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
|
|||
|
|||
=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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |