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

½Ð¦U¦ì¥ý¶i¤Î¤j¤jÀ°¦£§Ú§Ö¥¢¥h°Ê¤O¤F

½Ð¦U¦ì¥ý¶i¤Î¤j¤jÀ°¦£§Ú§Ö¥¢¥h°Ê¤O¤F

range("J3") = 3803761593029280

range("L3") = mid(right(range("J3") ,12),9,2)


µ²ªGÅܦ¨ EXCEL ¸Ì  L3 ªºµ²ªGÅܦ¨E+

¦Ó¤£¬O§Ú·Q­nªº 92

½Ð¦U¦ì¤j¤jÀ°§Ú¬Ý¬Ý¬°¤°»ò¤£¬O92

ÁÂÁ¦U¦ì¡A¯¬¦U¦ì¶¶¤ß¦p·N

¦^´_ 1# farmer900

L3=MID(RIGHT(J3,12),9,2)

TOP

ÁÂÁ¤j¤j¡A¬O§Ú¨SÁ¿²M·¡

³o­Ó§Ú¦³¥Î¥X¨Ó

¦ý¦b¥¨¶°ùØ­±«o¬O¤£¦æ

¦]¬°¥¦¥²¶·¶]¦^°é

©Ò¥H¥²¶·¥Î¥¨¶°


§Ú¦³¥ý¥Î³æ¤@´ú¸Õ¡A­Y´ú¸Õ¦¨¥\´N­nÅý¥L¶]¦^°é

¦ý²{¦b³s¦b¥¨¶°³æ¤@´ú¸Õ³£¥¢±Ñ

Á`¤§«ÜÁÂÁ±zªº¸Ñµª

TOP

¦^´_ 3# farmer900

J3³]©w¬°¤å¦r®æ¦¡
¦A¶]1¦¸µ{¦¡

TOP

¦^´_ 4# register313


   
3803761593029280 ©ñ¤J VBA

VBA¸Ì­±³ºÅܦ¨

range("J3") = 3.80376159302928E+15
Ãø©ÇÅܦ¨E+

¦ý§ÚÁÙ¬O·Q¤£¥X«ç»ò¨ú¥X92

TOP

¦^´_ 5# farmer900
  1. Sub AA()
  2. Range("L3") = Mid(Right(Range("J3"), 12), 9, 2)
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 6# register313


   

µ²ªG¦p¹Ï

TOP

¦^´_ 7# farmer900

J3³]©w¬°¤å¦r®æ¦¡
  1. Sub AA()
  2. Range("L3") = Mid(Right(Range("J3"), 12), 9, 2)
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 8# register313


   ÁÙ¬O¤@¼Ëªºµ²ªG

¦ý J3 Åܦ¨3.80376E+15 .....

¦b³o¥ýÁÂÁ¤j¤jªº¨¯­W

¹ï¤£°_...¤@ª½³Â·Ð±z¤F

TOP

¦^´_ 9# farmer900


    [L3] = Mid(Right(Format([J3], "0"), 12), 9, 2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD