excel肿么把数字反过来粘贴

什麼意思?是要把数字如12345倒转为54321，123倒转为321吗?A1输入数字B1=SUM九短PRODUCT(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))----数组公式