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

[µo°Ý] ±Æ§Ç°ÝÃD~

[µo°Ý] ±Æ§Ç°ÝÃD~

·Q½Ð°Ý¤@¤U­Ó¦ì°ª¤â~~§Ú¦bexcel ±Æ§Ç¤W¦³°ÝÃD~BÄæ¬O·Ó¤j¤p±Æ§Ç,·Q§e²{ªº¬O¹³DÄæ¤@¼Ë
¦³¿ìªk¹F¨ì¶Ü? ¦]¼Æ¾Ú«Ü¦h


test.zip (6.88 KB)

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

TOP

A2 =--LEFT(B2&"0000",5)
¤U©Ô

¿ï©w½d³ò«á¥HAÄæ±Æ§Ç
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂ2¦ì¤j¤jªº¦^ÂÐ,¤w¥i¥H¨Ï¥Î

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD