excel表格倒着输入怎么取消

1.excel让数字倒序后去掉小数点

公式=SUM(LOOKUP(ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,".","")))),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,".","")))),MID(SUBSTITUTE(A1,".",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,".","")))),1))*10^(ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1,".",""))))-1））按ctrl+shift+回车，使用组公式。