You need to format negative numbers with either a negative sign or parentheses marks for them to be treated as a negative number. If you only used a special color like red to format your negative numbers, the import won’t treat the numbers as negatives. Verify that at a minimum you used a negative sign or parentheses for negative numbers when you set up the import file. The format shown in the second column below is an example of a valid negative number format for an import.