If I do

Range ("a1") = timer

on a loop then it refreshes showing fractions of a second, but shows
whatever large number the timer is at


However if i do


tim = Timer
Do

diff = Timer - tim
Range("a1") = diff

loop

then it counts up from zero, as intended, but for some reason drops all the
decimal places

Anyone know why it drops the decimals and how to make it keep the decimals?

Many thanks