In VBA, you need to use US formatted number

Range.Value = 0.99999

(no quotes, use period rather than comma).

--
Regards,
Tom Ogilvy

"Klimaks" wrote in message
...

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

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

What should I do?


--
Klimaks
------------------------------------------------------------------------
Klimaks's Profile:
http://www.excelforum.com/member.php...o&userid=14656
View this thread: http://www.excelforum.com/showthread...hreadid=263797