Сд×Öĸ½ð¶îת´óдÊÇÒ»¿îÊ®·ÖÓ¦ÓõÄʵÓù¤¾ß£¬Ëü¿ÉÒÔ½«ÊäÈëµÄСдÊý×Ö½ð¶î¾«È·µØ±ä»»Îª´óдÊý×Ö½ð¶î£¬±ã½Ý»á¼ÆÓйØÒªÇóÓ¦Óá£ÈÈÁÒ»¶Ó­ÓÐÐëÒªµÄС»ï°éÇ°È¥¶àÌØÏÂÔØ£¡

ʹÓ÷½·¨

1.ÊäÈëÊý¾Ý½ð¶î

2.°´×¡»Ø³µ¾Í¿ÉÒÔ

ExcelСдת´óд

ÉèA1ÁÐÈëÊý¾ÝÐÅÏ¢ÁУ¬ÔòÔÚA2ÊäÈëÏÂÁй«Ê½¼ÆËã(¿É¿½±´):

=IF(A1lt;0,¸º,)IF(ABS(A1)gt;1,TEXT(TRUNC(ABS(ROUND(A1,2))),[DBNum2])Ôª,)IF(ISERR(FIND(.,ROUND(A1,2))),,TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),[DBNum2]))IF(ISERR(FIND(.0,TEXT(A1,0.00))),½Ç,)IF(LEFT(RIGHT(ROUND(A1,2),3))=.,TEXT(RIGHT(ROUND(A1,2)),[DBNum2])·Ö,Õû)

WordСдת´óд

µÚÒ»ÖÖ·½Ê½£ºÏÈÑ¡¶¨Òª¸ÄµÄɳÌØ°¢À­²®Ð¡Ð´Êý×Ö£¬Ëæºóµãһϲå½ø²Ëµ¥À¸£¬µãһϲå½øÊý¾ÝÑ¡ÔñÏ¸ù¾ÝÍùÏÂÀ­Ñ°ÕÒÖÐÎÄ´óд½ð¶îÎļþ¸ñʽ£¬µãÒ»ÏÂÃ÷È·¾Í¿ÉÒÔÁË¡£

µÚ¶þÖÖ·½Ê½£ºÔËÓÃËѹ·ËÑË÷ÊäÈë·¨×÷Óã¬ÏÈÊäÈëÒ»¸öv£¬ºó±ßÊäÈëÊý¾Ý£¬±ã»áµ¯³öÀ´Ó¢ÎÄ´óд½ð¶î£¬Ñ¡¶¨ÏàÆ¥ÅäµÄ¾Í¿ÉÒÔÁË£¬ÊÇ·ñ·Ç³£¼òµ¥£¿

Ïà¹ØÐÅÏ¢

ÖìԪ谶ԡ°¹ù»¸Ì°ÎÛ°¸¡±´ó·ù´óÅ­£¬Ç××ÔÏÂÖ¼½«¹ù»¸µÈͬ°¸·¸ÉÏÍòÈËÕ¶Ê×ʾÖÚ¡£Îª·´¸¯Ê÷Á®£¬ÖìԪ谻¹Öƶ©ÁËÑÏ¿ÁµÄ³Í´¦¾­¼Ã·¸×ïµÄ·¨°¸£¬ÔÚÈ«¹ú¸÷µØ²ÆÎñ»á¼ÆÉÏÍÆÐÐÁËһϵÁкÏÀí¶Ô²ß£¬ÔÚÆäÖÐ×îÖØÒªµÄÒ»Ìõ±ãÊǰѼÇÊöÇ®Á¸Êý¾ÝµÄÖйúºº×Ö¡°Ò»¶þÈýËÄÎåÁùÆ߰˾ÅÊ®°Ùǧ¡±£¬¸Ä³ÉÎÞ·¨Ð޸ĵÄÓ¢ÎÄ´óд¡°Ò¼·¡ÈþËÁÎé½Æâ°Æ¾ÁÊ°°ÛǪ¡±¡£Òò¶ø£¬ÓÐЩÈ˾õµÃÖйúÀúÊ·ÉϽð¶îÊý×Ö´óдµÄµì»ùÕßÓ¦ÊÇÖìԪ谡£