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

[µo°Ý] ±ý±N¡i10.5 ¤p®É¡j¥H¡i1¤Ñ2.5®É¡j§e²{¥X¨Ó¡A ¤½¦¡¸Ó «ç¼Ë¼g?

[µo°Ý] ±ý±N¡i10.5 ¤p®É¡j¥H¡i1¤Ñ2.5®É¡j§e²{¥X¨Ó¡A ¤½¦¡¸Ó «ç¼Ë¼g?

½Ñ¦ì¤j¤j,§A¦n!
½Ð°Ý¡G1¤Ñ8¤p®É¡A¥H¥b¤p®É¬°­pºâ³æ¦ì¡A
±ý±N¡i10.5 ¤p®É¡j¥H¡i1¤Ñ2.5®É¡j§e²{¥X¨Ó¡A
¤½¦¡¸Ó «ç¼Ë¼g?

Book1.zip (1.64 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2018-5-8 14:28 ½s¿è

¦^´_ 1# yen956
Àx¦s®æB8¿é¤J
=IF(INT($A8/8)=0,MOD($A8,8)&"®É",IF(MOD($A8,8)=0,INT($A8/8)&"¤Ñ",INT($A8/8)&"¤Ñ"&MOD($A8,8)&"®É"))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò

TOP

B8 =TEXT(INT(A8/8),"0!¤Ñ;;;")&TEXT(MOD(A8,8),"[<>]0.0®É;;;")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2018-5-8 15:43 ½s¿è

¦^´_ 3# ML089
ML089¤j¡A±z¦n¡I
½Ð°Ý
1) ¨ç¼ÆTEXT(value, format_text)ªºformat_text¡]0!¤Ñ;;;»P[<>]0.0®É;;;¡^±q­þ¨à¥i²ß±o±z³o¥Îªk¡H¡]Excel¤º«Ø»¡©ú¬dµL¬ÛÃö»¡©ú¡^
2) 0!»P[<>]0.0¤À§O¥Nªí¤°»ò·N«ä¡H
3) ¬°¦ó¡u¤Ñ¡v»P¡u®É¡v¤§«á­n¥[¡u ;;; ¡v¡H¬°¤°»ò­n¥[3­Ó¤À¸¹¡H
Àµ½Ð½ç±Ð¡AÁÂÁ¡I

TOP

RE: ±ý±N¡i10.5 ¤p®É¡j¥H¡i1¤Ñ2.5®É¡j§e²{¥X¨Ó¡A ¤½¦¡¸Ó «ç¼Ë¼g?(¤w¸Ñ¨M)

¦^´_ 3# ML089
ÁÂÁ¤j¤j§Ö³tªº¦^ÂÐ, ¤j¤jªº¤½¦¡¥¿¦X©Ò¨D,
ÁÂÁÂ!!

TOP

¦^´_ 2# p212
ÁÂÁ§Aªº¦^ÂÐ, ¥¿¬O·Q­nªº¤½¦¡, ÁÂÁÂ!!

TOP

¦^´_ 4# p212

1) ¨ç¼ÆTEXT(value, format_text)ªºformat_text¡]0!¤Ñ;;;»P[<>]0.0®É;;;¡^±q­þ¨à¥i²ß±o±z³o¥Îªk¡H¡]Excel¤º«Ø»¡©ú¬dµL¬ÛÃö»¡©ú¡^
¦^ÂСG³}½×¾Â¬Ý§O¤H¥Î´N¾Ç°_¨Ó¡A¤£°O±o¦b­þ¸Ì¬Ý¨ìªº¡C

2) 0!»P[<>]0.0¤À§O¥Nªí¤°»ò·N«ä¡H
¦^ÂСG=TEXT(INT(A8/8),"0!¤Ñ;;;")&TEXT(MOD(A8,8),"[<>]0.0®É;;;")
!¤Ñ¡A!´N¬OÅã¥Ü«á­±ªº¦r¤¸"¤Ñ"
[<>] ªí¥Ü¤£µ¥©ó 0 ¥þ³¡¥H 0.0 ®æ¦¡Åã¥Ü¡A"®É"ªº«e­±À³¸Ó¹³"¤Ñ"¥[¤W ! ¤ñ¸û¤£·|¿ù¡A³o³¡¤À§Ú¤]¤£¬O«Ü²M·¡¡A¤j³¡¤À«DTEXT®æ¦¡¦r¤¸¬O¤£¥Î«e¥[ "!"¡A¦ý¦³¨Ç´N»Ý­n¡A¦³®É»Ý­nTRY¤~ª¾¹D¡C

3) ¬°¦ó¡u¤Ñ¡v»P¡u®É¡v¤§«á­n¥[¡u ;;; ¡v¡H¬°¤°»ò­n¥[3­Ó¤À¸¹¡H
¦^ÂСGTEXT(¼Æ¦r¡A®æ¦¡)¡A®æ¦¡°Ï¤À¬°¥|¬qª¬ªp¥Î ; ¤À¶}¡A "¥¿; ­t; ¹s; ¤å¦r"¡A¬°¤°»ò­n¥[3­Ó¤À¸¹ ;;;¡Hªí¥Ü«á­±3ºØª¬ªp³£¤£¿é¥X¡C

TEXT ¨ç¼Æ¤¤ ®æ¦¡¹B¥Î«Ü¦h¥i¥Hºô¸ô¬d¸ß¤@¤U¡A ¨ä¹ê§A¦b EXCELªíÀH·N¿ï¤@®æ¡A¥kÁä - Àx¦s®æ®æ¦¡ - [¤W¦C¿ï¶µ]¼Æ­È - ¦Û­q - ¿ï¨ú¥k¤U®Ø¤º®æ¦¡¡A¦b Ãþ«¬¤U¤è®æ¦¡¿é¤JÄæ ´N·|¥X²{³]©w¤è¦¡¡A³o¨Ç³£¥i¥HÀ³¥Î¦Ü TEXT¨ç¼Æ ¤º®æ¦¡³]©w¡C
¤]¥i¥H  [¤W¦C¿ï¶µ]¼Æ­È - ¯S®í -  ¿ï¾Ü ¦æ°Ê¹q¸Ü ©Î ¹q¸Ü¸¹½X7¡B8¦ì¼Æ - ¦AÂI¿ï ¦Û­q¡A¥i¥HÆ[¹î ®æ¦¡ªº³]©w¤è¦¡¡A´N¥i¥H¹B¥Î¦Ü TEXT ¨ç¼Æ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=IF(A8<8,,INT(A8/8)&"¤Ñ")&IF(MOD(A8,8),MOD(A8,8)&"®É",)

12 = 1¤Ñ4®É

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2018-5-9 11:03 ½s¿è

¦^´_ 7# ML089
¶W¯Å¥Ñ°J·P¿E ML089¤j ¼ö¤ßµL¨pªº±Ð¾Ç
¤W¤FÄ_¶Qªº¤@½Ò, ÁÂÁ¡I

TOP

¦^´_ 7# ML089
·PÁ¶Wª©ªº¸Ô²Ó»¡©ú, ÁÂÁÂ!!
¤]ÁÂÁÂP212¤j¤jªº´£°Ý(§Ú¤]·Q°Ý), ÁÂÁÂ!!
ÁÂÁ­ã¤jªº¤½¦¡, ºë²©öÀ´!!ÁÂÁÂ.

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD