If you're interested in 3 decimals then either
=TEXT(MOD(SUM(A1:A6),1)*1000,"000")
or
=REPLACE(TEXT(MOD(SUM(A1:A6),1),".000"),1,1,"")
both of the above will return text strings in format of ### ... I am assuming that is your preference
(ie not a Custom Format)
Bookmarks