I have created 14 sheets with different titles all created independently, on
one of them I put in the date in A2, in B2 I put in number "1" and it
entered ok, in C2 I put "3" and it entered ok, in D2 I put in 1.75 and it
entered as JAN 05.

It only happened on the one sheet, as we tried it on two of the other
sheets, why might this be.

Cheers Steve