Hi all

I want to insert a particular data into a cell via VBA code. This is my code:

Cells(ActiveCell.Row, "D").NumberFormat = "[h].mm.ss"
Cells(ActiveCell.Row, "D") = "8.3" '8 hours and 03 minutes

Why after executing this code the cell contains 199.12.00 and not 8.03.00?
Please help!

PS: if i enter manually '8.3', excel correctly format cell as '8.03.00'...