Why does a VBA format function work like this?

Question

Why does the format ("1A", "0.000000") return 0.041667?

Answer 1

0.041667 1/24 , so its interpretation of 1A as 1 AM

 ?cdate(Format("1A","0.000000") ) 01:00:00 

Pass "1A" to val() to extract 1 if what you want is not yet called in format if the input is not numeric.