C2=IF(ISERR(FIND(".",B2)),B2/10^(LEN(B2)-1)&"*10^"&LEN(B2)-1,LOOKUP(1,0/(B2*10^ROW($1:$9)<10),10^ROW($1:$9))*B2&"*10^-"&LOOKUP(1,0/(B2*10^ROW($1:$9)<10),ROW($1:$9)))
另解=LOOKUP(1,0/(B2*10^(ROW($1:$19)-10)<10),B2*10^(ROW($1:$19)-10))&"*10^"&LOOKUP(1,0/(B2*10^(ROW($1:$19)-10)<10),ROW($1:$19)-10)*-1
取小數點一位=SUBSTITUTE(SUBSTITUTE(TEXT(B2,"0.0E+0"),"E+","*10^"),"E-","*10^-")
另解=B2/10^INT(LOG10(B2))&"*10^"&INT(LOG10(B2))
留言
張貼留言