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

[µo°Ý] ½Ð°ÝÀx¦s®æ¦¡Âà´«¦¨¥i­pºâªº¼Æ¦r¤½¦¡

[µo°Ý] ½Ð°ÝÀx¦s®æ¦¡Âà´«¦¨¥i­pºâªº¼Æ¦r¤½¦¡

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-2 13:39 ½s¿è

½Ð°Ý¥ý¶i
A2ªºÀx¦s®æ¦¡±q§OªºÀɮ׳sµ²¹L¨Ó..¼Æ¦rµLªk­pºâ
¥i¥H½Ð°Ý¦bB2Âà´«¦¨¥i­pºâªº¼Æ¦r
ÅýD2­pºâ
½Ð°ÝB2®æ¦¡¦p¦ó¦Û­q©Î¬O¤½¦¡
¦A½Ð°ÝD2®æ¦¡¥i¥H¦Û­q¦³Åã¥Ü"¤¸"¶Ü?
ÁÂÁÂ..

¦^´_ 1# PD961A

B2ªº¤½¦¡
  1.    =VALUE(MID(A2,2,LEN(A2)-2))
½Æ»s¥N½X
¦Û­q®æ¦¡:
  1. $#,##0.00"¤¸"
½Æ»s¥N½X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_  PD961A

B2ªº¤½¦¡¦Û­q®æ¦¡:
kimbal µoªí©ó 2010-7-29 20:42


ª©¥DÁÂÁ±z
¥i¥H±a¤J¨Ï¥Î
¥t¥~¥i¥H½Ð°Ý±z¦Û­q®æ¦¡¦³¤@©wªº³W«h¥h³]©w¶Ü?
(­Y¦³ªº¸Ü½Ð°Ý¥i¥H¨ì­þ¸Ì§ä¬ÛÃöªº¸ê®Æ¾Ç²ß)
©Ò¥H·Q½Ð°Ý±z    "$#,##0.00"¤¸""  
#,##³o­Óªº¥Nªí²[¸q¬O¤°»ò?
ÁÂÁ±z

TOP

¦^´_ 3# PD961A

#,##0 ¶W¹L¤@¤d´N·|¥X²{¤d¤À¸¹
½Ð°Ñ¦Ò
http://tw.myblog.yahoo.com/jw!Di ... fM-/article?mid=587

TOP

¦^´_ 4# jackdream


    jackdream¥ý¶i
ÁÂÁ±z
¥i¥H¥t¥~½Ð°Ý±z
ªü¦Nª©¥D¦³­Ó¦Û­q®æ¦¡";;;"¬O¥Nªí¤°»ò·N«ä?
±zµ¹ªººô¯¸¨S¦³³o¼Ëªº³]©w...
ÁÂÁÂ..

TOP

¦^´_  jackdream
¦³­Ó¦Û­q®æ¦¡";;;"¬O¥Nªí¤°»ò·N«ä?
PD961A µoªí©ó 2010-7-30 13:03


Åý¸ÓÀx¦s®æ¤£Åã¥Ü¸ê®Æ(¦]µL¥ô¦ó©w¸q)

¦]¬°¨C¤@­ÓÀx¦s®æ¦@¦³¥|­Ó°Ï¬q¡A¨C­Ó°Ï¬q¥H¤À¸¹°Ï¹j¡u¥¿¼Æ;­t¼Æ;¹s;¤å¦r¡v
·íÀx¦s®æ¦Û­q¬° ;;; ®É,¥NªíµL¥ô¦ó©w¸q,©Ò¥H¤£·|Åã¥Ü¸ê®Æ.
½Ð°Ñ¦Ò http://office.microsoft.com/zh-hk/excel-help/HP001216503.aspx

TOP

B2ªº¤½¦¡
  1. =VALUE(SUBSTITUTE(SUBSTITUTE(A1,"$",""),"¤¸",""))
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-4 13:10 ½s¿è

¦^´_ 7# ivanyung


    ÁÂÁ±zªº¤½¦¡¥i¥H¾A¥Î
¥i¥H½Ð°Ý±z
(SUBSTITUTE(H1259,"$","")©M
SUBSTITUTE(SUBSTITUTE(H1259,"$",""),"¤¸",""
¦A¦h¤@¼h¨ú¥N"¤¸"½Ð°Ý®t§O¦b­þ¸Ì?
ÁÂÁÂ

TOP

¦^´_  ivanyung


    ÁÂÁ±zªº¤½¦¡¥i¥H¾A¥Î
¥i¥H½Ð°Ý±z
(SUBSTITUTE(H1259,"$","")©M
SUBSTITUTE(S ...
PD961A µoªí©ó 2010-8-2 13:38

°²³]¦r¦ê¬O¡§$123,456 ¤¸¡¨
²Ä¤@¦¸¬O±N "$" Âà´«¬° "", ³o®É¦r¦ê·|Åܦ¨ ¡§123,456 ¤¸¡¨¡A©Ò¥H­n¦A±N "¤¸"Âà´«¬° ""¡C

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-4 13:10 ½s¿è

¦^´_ 9# ivanyung


    °²³]¦r¦ê¬O¡§$123,456 ¤¸¡¨
      ²Ä¤@¦¸¬O±N "$" Âà´«¬° "", ³o®É¦r¦ê·|Åܦ¨ ¡§123,456 ¤¸¡¨¡A©Ò¥H­n¦A±N "¤¸"Âà´«¬° ""¡C
     ½Ð°Ý³]'=SUBSTITUTE(H1,"$","")´N¥i¥HÂন123,456 ¤¸®æ¦¡¤]¬O'´¶³q"®æ¦¡
     ¦ý¬O¤£¯à­pºâ. ©Ò¥H¤~­nÂà´«¤¸¬°""..³o¼Ë¤~¯à­pºâ¬O¶Ü?ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD