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

[µo°Ý] ¤Q¶i¨î»P¤Q¤»¶i¨î¤G¾Ü¤@¨Ã±N¨äÂà´«¦¨¤G¶i¨î¨Ã¥[¥H±Æ¦C

[µo°Ý] ¤Q¶i¨î»P¤Q¤»¶i¨î¤G¾Ü¤@¨Ã±N¨äÂà´«¦¨¤G¶i¨î¨Ã¥[¥H±Æ¦C

½Ð°Ý¦U¦ì¤j¤j
¤Q¶i¨î(A1)»P¤Q¤»¶i¨î(A2)¤G¾Ü¤@¨Ã±N¨äÂà´«¦¨¤G¶i¨î¨Ã¥[¥H±Æ¦C¦ÜA7~D10
»¡©ú¦pªþ¹ÏEÄæ¦ì

Q10.rar (8.39 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2022-8-29 14:01 ½s¿è

A7:D10=MID(TEXT(A$6,"0000"),ROW(A1),1)


https://blog.xuite.net/hcm19522/twblog/590519867
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522



½Ð°Ý¤j¤j~A4¬O±NA3¤Q¶i¨îÂà´«¬°16¶i¨î ,±a¤J¤½¦¡ DEC2HEX(A3) ¥u·|±o¨ìC18¦ý¬O«e­±ªº "0"µLªkÅã¥Ü
¦b±N­Ó§O¶ñ¤JA7~D10®É´NÅܦ¨¤FC180

½Ð°Ý­n¦p¦ó­×§ï¨ç¼Æ
2022-08-29_143241.jpg
ÁÂÁÂ

TOP

¦^´_ 3# marklos


    TEXT(~,"0000") ¤Æ¦¨¥|¦ì¼Æ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD