I insert a value with a Range.Value = "0,99999".

The cell where I insert as the following format "hh:ss". But the value
are inserted like "0,9999". When I edit the value and press enter the
suddenly get the correct format?

What should I do

--
Klimak
-----------------------------------------------------------------------
Klimaks's Profile: http://www.excelforum.com/member.php...fo&userid=1465
View this thread: http://www.excelforum.com/showthread.php?threadid=26379