The conversion is done for single arguments only, as in =A1+A2, or = &quot; 1E2 &quot; +1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string. Strings inside formulae are also converted, such as in = &quot; 1999-11-22 &quot; +42, which returns the date 42 days after November 22nd, 1999.
转换只对单个参数执行，例如 =A1+A2 或 = &quot; 1E2 &quot; +1。单元格区域参数不受影响，因此如果两个单元格中至少有一个包含可转换字符串，则 SUM(A1:A2) 就不同于 A1+A2。