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

[µo°Ý] dde to excel ½Ð±Ð

[µo°Ý] dde to excel ½Ð±Ð

=ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0)

¥H¤WÁä±µÅã¥Ü¼Æ­È®É«ç¼Ë­×§ï¤~¯àÁôÂíӦìÅã¥Ü¡H

¨Ò¡G345>34

ÁÂÁÂ

=LEFT(ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0),LEN(ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0))-1)

TOP

¦^´_ 2# ANGELA


    ÁÂÁÂANGELAªº¦^ÂСA³o­Ó°ÝÃD¸Ñ¨M¤F¥t¤@­Ó°ÝÃD¤S¥X²{¡AÁ`¬O¤£¯à¤@¦¸¹Lªí¹F¥X¨Ó¡A¯u¹ï¤£°_...

¨Ò¡G345>34 / 34>3.4

TOP

¤£¤F¸Ñ

TOP

¦^´_ 4# ANGELA


    §Æ±æ¶Ç¨Ó2¦ì¼Æ­È®É¯àÅã¥Ü±o²M·¡¤@ÂI¡C

¨Ò1¡G345=34
¨Ò2¡G34=3.4

ÁÂÁÂ

TOP

a1¥Nªí¶Ç¦^­È
=IF(LEN(A1)>2,LEFT(A1,LEN(A1)-1),LEFT(A1)&"."&RIGHT(A1))

TOP

¹ï¤£°_¡IÁÙ¬O¤£¯à°÷§â³o±ø¤½¦¡

=IF(LEN(A1)>2,LEFT(A1,LEN(A1)-1),LEFT(A1)&"."&RIGHT(A1))

(a1¥Nªí¶Ç¦^­È)

¥N¶i

=LEFT(ROUNDDOWN(xxxxxx|'R1A'!'+138@1:1',0),LEN(ROUNDDOWN(xxxxxx|'R1A'!'+138@1:1',0))-1)

¤º¨Ï¥Î¡C

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-9-29 09:45 ½s¿è

=IF(LEN(A1)>2,LEFT(A1,LEN(A1)-1),LEFT(A1)&"."&RIGHT(A1))

¨ä¤¤¬õ¦âªºA1¥Î LEFT(ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0),LEN(ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0))-1)
¨ú¥N

TOP

(A1)

¬O§_¥Nªí(ROUNDDOWN(xxxxxxx|'R1A'!'+138@1:1',0)³o­ÓddeÁä±µ¡H

TOP

´«­Ó¤è¦¡»¡§a,
XX=LEFT(ROUNDDOWN(xxxxxx|'R1A'!'+138@1:1',0),LEN(ROUNDDOWN(xxxxxx|'R1A'!'+138@1:1',0))-1)
=IF(LEN(XX)>2,LEFT(A1,LEN(XX)-1),LEFT(XX)&"."&RIGHT(XX))

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD