"Bernard Liengme" wrote in message
...

The value must be entered as '0500450002883 to preserve the leading zero

You could always force it

=MOD(SUMPRODUCT(--(MID(TEXT(A1,"0000000000000"),ROW(INDIRECT("1:12") ),1)),RO
W(INDIRECT("1:12"))),9)