Сд±ä´óдexcel,µç×Ó±í¸ñСд±ä´óдת»»Æ÷
1. Сд±ä´óдת»»Æ÷
ͨ¹ýת»»Æ÷³ÉΪ´óд£¬·Ö±ðÊÇ:A¡¢B¡¢C¡¢D¡¢E¡¢F¡¢G¡¢H¡¢I¡¢J¡¢K¡¢L¡¢M¡¢N¡¢O¡¢P¡¢Q¡¢R¡¢S¡¢T¡¢U¡¢V¡¢W¡¢X¡¢Y¡¢Z¡£Ê×Ïȸ´ÖƵ½wordÎĵµ£¬È»ºóÑ¡ÔñÄãÒª¸ÄΪ´óдµÄÓ¢ÎÄ£¬Í¬Ê±°´shiftºÍf3£¬°´µÚÒ»´Î»á±ä³ÉÊ××Öĸ´óд£¬°´µÚ¶þ´Î¾ÍÈ«²¿´óд¡£A×Öĸ´óдʱռÉÏ¡¢ÖÐÁ½¸ñ£¬ÇÒÇãб10¶È×óÓÒ£¬Ð¡Ð´×ÖĸaÔÚÖиñ¡£
B×Öĸ´óдʱռÉÏ¡¢ÖÐÁ½¸ñ£¬Ð¡Ð´×ÖĸbͬÑùÕ¼ÉÏ¡¢ÖÐÁ½¸ñ¡£
2. Êý×Ö´óдת»»Æ÷
Êý×Öת»»´óд¹¤¾ßʹÓÃ˵Ã÷£º
½«°¢À²®Êý×Ö¸´ÖÆÕ³Ìù»òÊäÈëµ½¡°ÊäÈëСдÊý×Ö½ð¶î¡±ÖУ¬±ÈÈ磨123456£©£¬È»ºóµ¥»÷¡°×ª»»Îª´óд½ð¶î¡±°´Å¥¡£¾Í»áÔÚ¡°ÏÔʾÖÐÎÄ´óд½ð¶î¡±¿òÖÐÏÔʾ×Ô¶¯×ª»»Íê³ÉµÄÖÐÎÄ´óдÄÚÈÝ¡£×îºó¸´ÖÆת»»Íê³ÉµÄÄÚÈݵ½Ïëµ½µÄµØ·½Õ³Ìù¼´¿É¡£
ÈËÃñ±Ò·ûºÅ:£¤£»ÃÀÔª·ûºÅ£º$£»Å·Ôª·ûºÅ£º€£»Ó¢°÷·ûºÅ£º¡ê£¨»õ±Ò·ûºÅ¿ÉÖ±½ÓÊó±êÑ¡Öкó¸´ÖÆʹÓã©¡£
3. Сдת»»³É´óдת»»Æ÷
4567´óдÊÇËÁÎé½Æâ
4. СдÔõôת»»´óд
¿ÉÒÔʹÓõÚÈý·½ÊäÈë·¨£¬ÀýÈçËѹ·ÊäÈë·¨À´ÊµÏÖ£º
1¡¢ÔÚµçÄÔÉÏ°²×°ÓÐËѹ·ÊäÈë·¨µÄ»°£¬È磤20151227.00Ôª£¬ÐèҪװ»»³É´óд£¬ÎÞÂÛÔÚʲôÈí¼þÖлòÕßÍøÒ³ÖУ¬Ö»Òª¿ÉÒÔÊäÈëÄÚÈÝ£¬Ö»Ð谴ϼüÅÌÉϵġ°V¡±¼ü£¬¼´¿É³öÏÖÏÂÃæµÄ½á¹û£º
2¡¢ÔÚºóÃæÊäÈëÐèҪת»»µÄÊý×Ö£¬È磤20151227.00
3¡¢È»ºó°´Ï¼üÅÌÉϵġ°b¡±¼ü£¬½á¹û¾ÍÊÇÐèÒªµÄ´óд½ð¶î¡£
4¡¢Í¬Àí£¬Èç¹ûÐèÒª²åÈëʱ¼ä»òÕßÈÕÆÚ£¬Ò²¿ÉÒÔ¡£ÊäÈë¡°v2104.12.27¡±
5¡¢°´Ï¼üÅÌÉϵġ°b¡±¼ü£¬ÊäÈ룺¶þ©–Ò»ËÄÄêÊ®¶þÔ¶þÊ®ÆßÈÕ(ÐÇÆÚÁù)¡£
5. ÈçºÎСдת»»´óд
¹«Ê½1£º=SUBSTITUTE(IF(RIGHT(FIXED(A1)*100,2)*1=0,TEXT(FIXED(A1),"[dbnum2]")&"ÔªÕû",SUBSTITUTE(SUBSTITUTE(REPLACE(TEXT(FIXED(A1),"[dbnum2]"),LEN(TEXT(FIXED(A1),"[dbnum2]")),0,"½Ç")&"·Ö",".","Ôª"),"Áã½Ç","Áã")),"-","¸º")
¹«Ê½2£º=IF(AND(A1<=-0.01,A1>=-0.99),"¸º","")&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(A1),"[dbnum2]G/ͨÓøñʽԪ;¸º[dbnum2]G/ͨÓøñʽԪ")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0½Ç0·Ö;[dbnum2]0½Ç;[dbnum2]Õû"),"Áã½Ç","Áã"),"Áã·Ö",)
¹«Ê½3£º=SUBSTITUTE(SUBSTITUTE(TEXT(INT(A1),"[DBNum2][$-804]G/ͨÓøñʽԪ"&IF(INT(A1)=A1,"Õû",""))&TEXT(MID(A1,FIND(".",A1&".0")+1,1),"[DBNum2][$-804]G/ͨÓøñʽ½Ç")&TEXT(MID(A1,FIND(".",A1&".0")+2,1),"[DBNum2][$-804]G/ͨÓøñʽ·Ö"),"Áã½Ç","Áã"),"Áã·Ö","")
¼Çס£ºÆäÖеÄA1£¬ÊÇÄã¶ÔÓ¦ÐèҪת»»µÄÁУ¬¸ù¾Ýʵ¼ÊÇé¿öÌæ»»¼´¿É¡£
6. Сд×Ô¶¯×ª»»´óд
Сд012345678910´óд¾ÍÊÇÁãÒ¼·¡ÈþËÁ°ÛÎé½ Æâ°Æ¾ÁÊ° ¡£
7. Êý×ÖСд±ä´óдת»»
ÈçºÎ°ÑÊý×ÖÇáËÉת»»³É´óд£¬ÌâÖ÷ûÓÐ˵ÊÇÓÃWORD»¹ÊÇEXCEL£¬ÏÈ¿´ÏÂÔÚEXCELÖеÄת»»·½·¨¡£
EXCELÊý×ÖСдת´óд¡£
´ò¿ªEXCELÊäÈëСдÊý×Ö£º
Ñ¡¶¨ºóÓÒ¼ü£¬µãÉèÖõ¥Ôª¸ñ¸ñʽ£º
ÔÚÌØÊâÖÐÑ¡ÖÐÎÄ´óдÊý×Ö£º
È·¶¨ºóת»»Íê³É£º
WORDÊý×ÖСдת´óд¡£
´ò¿ªWORDÊäÈëÊý×Ö£º
ÔÚ²åÈëÀ¸ÖÐÑ¡·ûºÅ£¬±àºÅ£º
ÔÚ±àºÅÖÐÑ¡´óдÊý×Ö£º
È·¶¨£¬×ª»»Íê³É£º
ÈçºÎ°ÑÊý×Öת»»³É´óд²Ù×÷ÑÝʾÍê³É
8. ´óдСдת»¯Æ÷
Êý×Öת»»Æ÷¹Ù·½°æÊÇÒ»¿î¼òµ¥ÊµÓõĽøÖÆת»»¹¤¾ß¡£Êý×Öת»»Æ÷×îаæÄܹ»°ïÖúÓû§ÇáËɵÄʵÏÖÊ®½øÖÆ¡¢Ê®Áù½øÖÆ¡¢¶þ½øÖÆÖ®¼äµÄÏ໥ת»»£¬ÊʺÏѧÉúºÍ±à³ÌÈËԱʹÓá£Êý×Öת»»Æ÷²Ù×÷·½·¨¼òµ¥£¬Óû§Äܹ»Ëæʱ½øÐÐÊý×Ö¼ÆËã¡¢¶àÖÖÊý×Ö½øÖÆת»»£¬Ê®·Ö·½±ã¡£
9. Êý×ÖСдת»»³É´óд¹¤¾ß
1¡¢¡¾Caps Lock¡¿£¬¸Ã¼üÓÃÀ´Çл»Ó¢ÎÄ´óСд¡£¡¾Caps Lock¡¿ÔÚ¼üÅÌ×î×ó²à£¬¡¾Tab¡¿¼üÓ롾Shift¡¿¼üÖ®¼ä£¬Ò»°ãÔÚÇл»³É´óд֮ºó£¬¼üÅÌÉϵÄָʾµÆÖмäµÄÒ»¸ö»áÁÁÆð£¬Ð¡Ð´Ê±²»ÁÁ£»
2¡¢°´×¡¡¾Shift¡¿¼ü£¬ÔÙ°´×Öĸ¼ü¾ÍÊÇ´óд×Öĸ£¬ËÉ¿ª±ä»ØСд£¬°´Ò»Ï¡¾Caps Lock¡¿£¬ÉÏÅŵĴóд¼üµÆÁÁ£¬ÕâʱºòÊäÈë×Öĸ¾ÍÒ»Ö±ÊÇ´óд¡£ÔÙ°´Ò»Ï£¬µÆϨÃ𣬱ä»Ø¡£
10. ÈçºÎ½«Ð¡Ð´×ª»»Îª´óд
ʾÀý²Ù×÷²½ÖèÈçÏ£º
1¡¢Ê×ÏÈ´ò¿ªwordÎĵµ£¬È»ºóÔÚÉÏ·½²Ëµ¥À¸µã»÷½øÈ롱²åÈë¡°²Ëµ¥¡£
2¡¢²åÈë²Ëµ¥ÖУ¬ÕÒµ½¡±±àºÅ¡°Ñ¡Ïµã»÷´ò¿ª¡£
3¡¢ÔÚµ¯³öµÄ±àºÅ¶Ô»°¿òÖУ¬ÕÒµ½µã»÷´óд½ð¶îµÄÑùʽ£¬È»ºóÔÚÉÏ·½±àºÅÊäÈëÐèÒªµÄСдÊý×Ö£¬µã»÷È·¶¨¼´¿Éת»»Îª´óд½ð¶î¡£
11. ´óдºÍСдת»»
wordÎĵµÀï¿ì½Ý¼üÊÇShift + F3£¬Ð¡Ð´×ª»»³É´óдÊÇ°´µÚÒ»ÏÂÊÇÊ××Öĸ´óд£¬°´¶þÏÂÊÇÈ«±ä´óд¡£