Hiya,

I currently have a cell that contains '=NOW()' and the number format is 'h:mm:ss'.

This gives the time that calculations in the file were last updated. Except that I want the cell to say, for example, '@ 1:13:14'.

If I put:
="@ "&NOW()
I get the time is full number format. Just wondered, how can I set it to h:mm:ss format?

----

Also, does anyone know how I can place a button which, when clicked, would recalculate all the formulas in the file (as if someone edited a cell and pressed enter).

Thanks!