ªð¦^¦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
2019-01-19_144036.JPG
2019-1-19 14:40


test.zip (6.88 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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 : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD