急问,excel数字太长最后几位为0但是要保留数值格式答:或者把所有所有过程列都省略,比如,A1+A2,这两个文本格式的数字相加,就是=LEFT(A2,LEN(A2)-10)+LEFT(A3,LEN(A3)-10)+IF(LEN(RIGHT(RIGHT(A2,10),10)+RIGHT(RIGHT(A3,10),10))>10,LEFT(RIGHT(RIGHT(A2,10),10)+RIGHT(RIGHT(A3,10),10),LEN(RIGHT(RIGHT(A2,10),10)+RIGHT(RIG...