excel表格怎么将数字倒转

1.excel怎么把数字反过来粘贴

什麽意思？是要把数字如12345倒转为54321,123倒转为321吗？A1输入数字B1=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*10^(ROW(INDIRECT("1:"&LEN(A1)))-1））或=SUMPRODUCT(TEXT(MID(A1,ROW($1:$9),1),"0;;;!0")*10^(ROW($1:$9)-1））或=SUM(IFERROR(MID(A1,ROW($1:$9),1)*10^(ROW($1:$9)-1),0））----数组公式。