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

[µo°Ý] ±N¨ú¥Xªº­ÈÅã¥Ü¬°¦Ê¤À¤ñ

[µo°Ý] ±N¨ú¥Xªº­ÈÅã¥Ü¬°¦Ê¤À¤ñ

½Ð±Ðª©¤Wªº¥ý¶i¡K¡K
§Ú·Q­n§â­È¨ú¥X¨Ó¡AµM«á¥ÎMSGBOXÅã¥Ü¥X¨Ó¡K¡K¦ý¬O¶]¥X¨Ó³£¬O¤p¼ÆÂIªº¼Ë¦¡¡K¡K
­n¦p¦ó±N¨ú¥Xªº­È³]©w¦¨¥H¦Ê¤À¤ñªº¤è¦¡Åã¥Ü©O¡H

¨Ò¡G
A2=0.989
Range("A2")=0.989

¦ý§Ú·Q­n¥¦Åã¥Ü¬°
98.9%

­n¦p¦ó´y­z¥¦©O¡H
ªì¾ÇVBA¥E¨ìtwbts

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-4-3 12:19 ½s¿è

¦^´_ 1# play9091
  1. Sub EX()
  2. MsgBox Format([A2], "#.#%")
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 1# play9091


    ´£¨Ñ¤@­Ó²Â¤èªk
   MsgBox Cells(2, 1) * 100 & "%"
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 3# hugh0620

¦^´_ 2# GBKEE

    ³á¡I¥i¥H¤F¡I·PÁ°ڡI
ªì¾ÇVBA¥E¨ìtwbts

TOP

MsgBox Format([A2], "#.#%") »P  MsgBox Cells(2, 1) * 100 & "%"
¨âªÌ¶¡¦U¦³¨ä¯S¦â¥ç¦³«Ü¦nªºªí¹F¡AµL©Ò¿×¤§Àu¦H¡C
³o´N¦n¤ñ¬O¤@­Ó¬ï¦è¸Ë¡A¥t¤@­Ó¥u¬ïŨ­m¥´»â±a¡A±z»¡©O¡H

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD