Hi sdoyle,

Excel ignores the leading zero and reads 91006 as 28th Feb 2049.
I don't know if there is a VBA solution but in normal circumstances
you have to follow Excels format.
To shorten your input you can use 9/10/6 and format the result
as you wish. The same amount of keystrokes just hitting the slash
at the top of the number pad instead of the zero at the bottom.

HTH
Martin