This is just a clarification for any new searches of this issue. It seems the more direct answer to the issue is a field that has been set as Text, but numbers are used. If someone adds a Alpha character or symbol to the field it is not normally a problem until you try to sum it in a report...