Cheers Bernard, i'll give that a try !

Kind Regards
Andrew


"Bernard Liengme" wrote in message
...
Unless you use Tools|Options|Calculate to change things, Excel
recalculates
whenever a new formula is entered. With =NOW() in A1, type 5 in C1 and 7
in
D1 and =C1+D1 in E1. Now wait a few minutes (make coffee) and change D1 to
20. When you hit the Enter key, nor only is E1 recalculated but so is E1
Alternatively use Format:Cell:Custom to format A1 as hh:mm:ss. Now you
need
wait only seconds

Somewhere, someone has an Excel clock. Try
http://www.j-walk.com/ss/excel/files/general.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andy100" wrote in message
...
I'm sure it has been asked before and seems a pretty simple question,
but
can excel automatically refresh (calculate now, F9) ??. i.e. if i wanted
to
make a simple clock in excel by entering " =now() " into a cell, could i
then make excel auto calculate this every second so that it keeps up
with
current time ??

Cheers
Andy