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

¶×¤JGOOGLE EXCEL ¦p¦ó¥¿±`Åã¥Ü¼Æ¦r¤å¦r

¥»©«³Ì«á¥Ñ samwang ©ó 2021-11-22 11:34 ½s¿è

¦^´_ 9# coafort

¤p§Ì´£¨Ñªºªþ¥óÅã¥Üªº³£¨S¦³00¡A¥¿±`À³¸Ó¬O00891
>>  E4=TEXT(C4,"00####")

TOP

¦^´_  coafort

¤p§Ì´£¨Ñªºªþ¥óÅã¥Üªº³£¨S¦³00¡A¥¿±`À³¸Ó¬O00891
>>  E4=TEXT(C4,"00####")
samwang µoªí©ó 2021-11-22 11:32


·P®¦¤j¤j¡A¥i¥H¤F:D

TOP

¦^´_  coafort

¤p§Ì´£¨Ñªºªþ¥óÅã¥Üªº³£¨S¦³00¡A¥¿±`À³¸Ó¬O00891
>>  E4=TEXT(C4,"00####")
samwang µoªí©ó 2021-11-22 11:32


½Ð°Ý¤j¤j
¦pªG§Ú¿é¤J2330
·|Åܦ¨002330
½Ð°Ý¦³¤èªk¸Ñ¨M¶Ü
ÁÂÁ¤j¤j

TOP

½Ð°Ý¤j¤j
¦pªG§Ú¿é¤J2330
·|Åܦ¨002330
½Ð°Ý¦³¤èªk¸Ñ¨M¶Ü
ÁÂÁ¤j¤j
coafort µoªí©ó 2022-4-6 07:45


±zªº»Ý¨D¬O­n³o¼Ë¶Ü?

1.JPG (112.37 KB)

1.JPG

TOP

±zªº»Ý¨D¬O­n³o¼Ë¶Ü?
samwang µoªí©ó 2022-4-6 08:32


³ø§i¤j¤j¡A¥Ø«e¬O¨Ì·Ó¤j¤j¤§«e´£¨Ñªº
=IF(Á`ªí!B2="","",TEXT(Á`ªí!B2,"00####"))
¤ñ¤è0050·|¥¿±`Åã¥Ü
¦ý¬O¸I¨ì«D00¶}ÀYªº
¤ñ¤è2330
´N·|Åܦ¨002330
¤£ª¾¹D¦³µL¤èªk¥i¥H¸Ñ¨M¨â­Ó³£¯à¥¿±`Åã¥Üªº¤èªk¡H
¤ñ¤è¥´0050´N·|Åã¥Ü0050
¥´2330´N·|Åã¥Ü2330
ÁÂÁ¤j¤j

TOP

¦^´_  coafort

·|¾É­P¨º­Ó°ÝÃD¡A¬O§A±N­ì©l¸ê®Æ¶×¦ÜExcelªº¤èªk¦Ó³y¦¨ªº¡A
¥i¥H¥Îcopy¤è¦¡¥iÁקK¶}ÀY" ...
samwang µoªí©ó 2021-11-22 09:39



¤§«e¤j¤j»¡¥i¥H¥Îcopy¤è¦¡
¤£ª¾¹D¦³µL¸Ñ¤è¡H
ÁÂÁ¤j¤j

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD