ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] excel­Èªº³]©w

[µo°Ý] excel­Èªº³]©w

¥»©«³Ì«á¥Ñ jj369963 ©ó 2021-1-1 10:49 ½s¿è

·Q±N¼Æ¾Ú¤¤ªº­È§ï®æ¦¡¡A¤]´N¬O¥ý¥|±Ë¤­¤J¨ì¤p¼Æ²Ä¤G¦ì¡A³Ì«á¤@¦ì¬O0¡A­nÁôÂáA¾ã¼Æ¦ì¥u¦³­Ó¦ì¼Æªº0 ¤]ÁôÂáC
¦p
0.238§ï¦¨  .24
0.102§ï¦¨   .1
10.701 §ï¦¨ 10.7
100.20 §ï¦¨ 100.2
103.01 §ï¦¨103.01

¦A³Â·Ð½Ð±Ð¦p¦ó¥Î¤½¦¡©Î¼Æ­È®æ¦¡¤Æªº¤è¦¡¨Ó§ó§ï

=TEXT(ROUND(A1,2),"[<1]#.##")

TOP

=MID(ROUND(B2,2),1+(B2<1),9)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD