"Rob Hick" wrote in message
oups.com...
You could try using

=TEXT(A1,"0.0000")

as the formula. I'm not sure how this would come out in CSV though.

cheers, that works a treat