『壹』 excel鏁板瓧鍙樺ぇ鍐欓噾棰濇柟娉
01 棣栧厛鎵撳紑浣犵殑鏁版嵁excel琛ㄦ牸錛屽傚浘 02 絎涓縐嶆柟娉曪紝鎶婂皬鍐欓噾棰濆嶅埗綺樿創鍒板ぇ鍐欓噾棰濈殑鍗曞厓鏍奸噷錛岀劧鍚庨変腑鍙沖嚮閫変腑 璁劇疆鍗曞厓鏍兼牸寮 03 鐒跺悗鍦ㄥ崟鍏冩牸鏍煎紡閲岄潰錛岄夋嫨 鐗規畩錛岀劧鍚庡湪鍙寵竟綾誨瀷閲岄夋嫨鏈鍚庝竴涓 浜烘皯甯佸ぇ鍐 04 瀹屾垚浠ャ
1鍋囪捐佽漿鎹㈢殑鏁板瓧灝忓啓閲戦濆湪A鍒2閫変腑瑕佽漿鎹㈢殑鏁板瓧鎵鍦ㄧ殑鍗曞厓鏍煎尯鍩燂紝鎸変笅CTRL+1緇勫悎蹇鎹烽敭錛屽脊鍑鴻劇疆鍗曞厓鏍兼牸寮忓硅瘽妗3鍦ㄢ滄暟瀛椻濋夐」鍗′笅鍗曞嚮鈥滅壒孌娾濋夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻濓紝鐒跺悗鍗曞嚮鈥滅『瀹氣濇寜閽4浠ヤ笂閫氳繃銆
澶嶅埗綺樿創姝ゅ叕寮忥紝鍗沖彲=IFTRUNCO15=0錛宷uotquot錛孴EXTTRUNCO15錛宷uotDBNum2G閫氱敤鏍煎紡quotquot鍏僸uotIFTRUNCO15*10TRUNCO15*10錛1=0錛孖FTRUNCO15*100TRUNCO15*100錛1lt0錛宷uot闆秖uot錛宷uotquot錛孴EXTTR銆
01 棣栧厛鎴戜滑鍙抽敭鍗曞嚮瑕佽劇疆鐨勬暟瀛楋紝鐒跺悗閫夋嫨璁劇疆鍗曞厓鏍兼牸寮忛夐」 02 鍦ㄥ脊鍑虹殑鐣岄潰涓銆
excel灝忓啓鍙樺ぇ鍐欓噾棰濇ラゅ備笅1鍋囪捐佽漿鎹㈢殑鏁板瓧灝忓啓閲戦濆湪A鍒楋紝濡傚浘鎵紺2閫変腑瑕佽漿鎹㈢殑鏁板瓧鎵鍦ㄧ殑鍗曞厓鏍煎尯鍩燂紝鎸変笅CTRL+1緇勫悎蹇鎹烽敭錛屽脊鍑鴻劇疆鍗曞厓鏍兼牸寮忓硅瘽妗嗭紝濡備笅鍥炬墍紺3鍦╨dquo鏁板瓧rdquo閫夐」鍗′笅鍗曞嚮銆
1excel閲岀殑鏁板瓧杞鎹㈡垚澶у啓閲戦濈殑鍏寮 鎴戜滑鍦˙2涓杈撳叆鍏寮=SUBSTITUTESUBSTITUTETEXTINTA2錛宷uotDBNum2$804G閫氱敤鏍煎紡鍏僸uotIFINTA2=A2錛宷uot鏁磓uot錛宷uotquotTEXTMIDA2錛孎INDquotquot錛孉2quot0quot+1錛1錛宷uot銆
寮瑰嚭鐨勭晫闈錛屾垜浠鐐瑰嚮鐗規畩錛岀劧鍚庢垜浠鐐瑰嚮涓鏂囧ぇ鍐欐暟瀛楋紝鐒跺悗鎴戜滑鐐瑰嚮紜瀹04 鏈緇堢粨鏋滃傚浘鎵紺猴紝榪欐牱鎴戜滑銆
1鍦ㄧ數瀛愯〃鏍肩殑絎涓鍒椾腑杈撳叆鏂囨湰鈥淧ROPER鈥濆嚱鏁拌兘灝嗘瘡涓鍗曞厓鏍奸噷鐨勬枃鏈鍙樻垚棣栧瓧姣嶅ぇ鍐欑殑褰㈠紡2娣誨姞鏂扮殑涓鍒楀彸閿鐐瑰嚮絎涓鍒楃殑瀛楁瘝鏍囬橈紝閫夋嫨涓嬫媺鑿滃崟涓鐨勨滄彃鍏モ3灝嗗厜鏍囩Щ鍔ㄥ埌絎涓涓鏂囨湰鍙充晶鐨勫崟鍏冩牸涓鐐瑰嚮銆
EXCEL鑷鍔ㄧ敓鎴愬ぇ鍐欓噾棰濆嚱鏁幫紝鎿嶄綔鏂規硶濡備笅1棣栧厛鍦ㄧ數鑴戜腑鎵撳紑excel錛岃緭鍏ヤ竴浜涙暟瀛楋紝鍒嗕負浼樻儬閲戦濆拰澶у啓閲戦2榪欐椂榧犳爣閫変腑琛ㄦ牸錛屽彸閿閫夋嫨璁劇疆鍗曞厓鏍兼牸寮3鎺ョ潃鍦ㄥ嚭鐜扮殑鍗曞厓鏍兼牸寮忓硅瘽妗嗕腑錛岄夋嫨鐗規畩浜烘皯甯佸ぇ鍐4銆
1棣栧厛鎵撳紑涓涓闇瑕佺敓鎴愮殑excel錛屽備笅鍥炬墍紺2鐒跺悗鐐瑰嚮鈥滆劇疆鍗曞厓鏍兼牸寮忊濓紝濡備笅鍥炬墍紺3閫夋嫨鈥滅壒孌娾濓紝濡備笅鍥炬墍紺4閫夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻濆悗錛岀偣鍑燴滅『瀹氣濓紝濡備笅鍥炬墍紺5榪欐椂灝忓啓鏁板瓧灝辮嚜鍔ㄥ彉鎴愬ぇ鍐欎簡錛屽傘
閫夋嫨灝忓啓鏁板瓧錛屽彸閿閫夋嫨璁劇疆鍗曞厓鏍兼牸寮忕壒孌婁腑鏂囧ぇ鍐欑『瀹氾紝濡傛灉鍙樻垚#鍙鋒槸鍗曞厓鏍煎皬浜嗘嫋鍔ㄥぇ涓鐐瑰氨鏄劇ず浜嗐
浣跨敤鑷瀹氫箟鏍煎紡鎴戜滑鍙浠ラ変腑鏁版嵁錛岀劧鍚庡彸閿錛岃劇疆鍗曞厓鏍兼牸寮忥紝鐒跺悗鍦ㄨ劇疆鍗曞厓鏍兼牸寮忎腑錛岄夋嫨鏁板瓧錛岄夋嫨鐗規畩錛岄夋嫨涓鏂囧ぇ鍐欐暟瀛楋紝渚垮彲浠ヨ漿鎹㈡垚鍔熶簡MS Office 鐗堟湰鍘嗗彶 Microsoft Office鏈鍒濈殑鐗堟湰鍦1989騫存墍鎺ㄥ嚭錛屾渶鍒濈殑榪愪綔鏄銆
$804G閫氱敤鏍煎紡鍒唓uot錛宷uot闆惰抭uot錛宷uot闆秖uot錛宷uot闆跺垎quot錛宷uotquot鎸夊洖杞﹂敭錛屽弻鍑諱箣鍚庡氨鑳借嚜鍔ㄥ～鍏咃紝榪呴熷皢灝忓啓鐨勬暟瀛楅噾棰濊漿涓烘爣鍑嗙殑浼氳＄殑澶у啓鏁板瓧閲戦漞xcel琛ㄤ腑灝忓啓鏁板瓧杞鎹涓哄ぇ鍐欓噾棰濈殑鏂規硶奼囨 excel琛ㄤ腑灝忓啓鏁板瓧杞鎹涓哄ぇ鍐欓噾棰濄
鐢∣ffice2016鎵撳紑琛ㄦ牸錛岄変腑鍗曞厓鏍煎悗榧犳爣鍙抽敭閫夋嫨鈥滆劇疆鍗曞厓鏍兼牸寮忊濋夋嫨鈥滄暟瀛椻濃滅壒孌娾濃滀腑鏂囧ぇ鍐欐暟瀛椻濆嵆鍙銆
1鎵撳紑闇瑕佹搷浣滅殑excel琛ㄦ牸錛岄栧厛鍦ˋ1鍗曞厓鏍煎唴杈撳叆闇瑕佽漿鎹㈡垚澶у啓閲戦濈殑鏁板瓧錛屼緥濡傛暟瀛椻879鈥2鐒跺悗鍦˙1鍗曞厓鏍煎唴杈撳叆鈥=鈥濈﹀彿錛岀敤鏉ュ紩鐢ㄨ＄畻鏁板肩殑鍗曞厓鏍3緇х畫杈撳叆瀹屾暣鐨勮漿鎹㈠叕寮=SUBSTITUTESUBSTITUTEIFRMB銆
浼楁墍鍛ㄧ煡錛孍xcel琛ㄦ牸鍦ㄨ儲浼氶嗗煙鐨勫簲鐢ㄦ槸闈炲父鐨勫箍娉涚殑錛岄偅涔堬紝Excel琛ㄦ牸褰撲腑濡備綍灝嗘暟瀛楅噾棰濊漿鎹㈡垚澶у啓閲戦濆憿1棣栧厛鎵撳紑excel錛岃緭鍏ヤ竴浜涢噾棰2鐒跺悗鍦˙2鍗曞厓鏍煎唴杈撳叆涓嬪垪鍏寮=IFMODA2錛1=0錛孴EXTINTA2錛宷uotDBNUM2銆
『貳』 excel涓鎬庝箞鎶婃暟瀛楅噾棰濊漿鎹㈡垚澶у啓
1銆佸亣璁捐佽漿鎹㈢殑鏁板瓧灝忓啓閲戦濆湪A鍒椼
2銆侀変腑瑕佽漿鎹㈢殑鏁板瓧鎵鍦ㄧ殑鍗曞厓鏍煎尯鍩燂紝鎸変笅CTRL+1緇勫悎蹇鎹烽敭錛屽脊鍑鴻劇疆鍗曞厓鏍兼牸寮忓硅瘽妗嗐
3銆佸湪鈥滄暟瀛椻濋夐」鍗′笅鍗曞嚮鈥滅壒孌娾濋夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻濓紝鐒跺悗鍗曞嚮鈥滅『瀹氣濇寜閽銆
4銆佷互涓婇氳繃璁劇疆鍗曞厓鏍煎紡鐨勬柟寮忓皢鏁板瓧杞鎹涓哄ぇ鍐欐暟瀛楋紝浣嗘槸騫舵病鏈変弗鏍兼寜鐓ц儲鍔″瑰ぇ灝忓啓閲戦濈殑杞鎹㈣佹眰銆
5銆佸傛灉瑕佷弗鏍兼寜鐓ц儲鍔″瑰ぇ灝忓啓閲戦濊漿鎹㈢殑瑕佹眰鏉ヨ達紝鍙浠ュ湪B2鍗曞厓鏍艱緭鍏ュ叕寮=SUBSTITUTE(SUBSTITUTE(TEXT(INT(A2),[DBNum2][$-804]G/閫氱敤鏍煎紡鍏&IF;(INT(A2)=A2,鏁,))&TEXT;(MID(A2,FIND(.,A2&.0)+1,1),[DBNum2][$-804]G/閫氱敤鏍煎紡瑙)&TEXT;(MID(A2,FIND(.,A2&.0)+2,1),[DBNum2][$-804]G/閫氱敤鏍煎紡鍒),闆惰,闆),闆跺垎,)錛岀劧鍚庢寜浣忛紶鏍囧乏閿鎷栧姩B2鍗曞厓鏍煎彸涓嬭掔殑濉鍏呮焺鍒癇鍒楃殑鍏跺畠鍗曞厓鏍煎尯鍩燂紝鍗沖彲銆
『叄』 鎬庝箞鎶奺xcel鐨勬暟瀛楀彉澶у啓
1. Excel鏁板瓧鎬庝箞杞鎹涓轟腑鏂囧ぇ鍐
涓銆佸崟鍏冩牸鏍煎紡娉
閫変腑閭ｄ簺鏁板瓧鎵鍦ㄧ殑鍗曞厓鏍礆紝鐐瑰嚮鍙抽敭錛屽湪寮瑰嚭鑿滃崟涓閫夋嫨鈥滆劇疆鍗曞厓鏍兼牸寮忊濆懡浠わ紝鎵撳紑鈥滆劇疆鍗曞厓鏍兼牸寮忊濆硅瘽妗嗐傜偣鍑燴滄暟瀛椻濋夐」鍗★紝鍦ㄥ乏渚х殑鈥滃垎綾燴濆垪琛ㄤ腑閫夋嫨鈥滅壒孌娾濓紝鐒跺悗鍦ㄥ彸渚х殑鈥滅被鍨嬧濆垪琛ㄤ腑鐐瑰嚮鈥滀腑鏂囧ぇ鍐欐暟瀛椻濓紝濡傚浘1鎵紺恆傜『瀹氬悗灝卞彲浠ヤ簡銆傝嫢鐐瑰嚮涓婃柟鐨勯偅涓鈥滀腑鏂囧皬鍐欐暟瀛椻濓紝鍙浠ュ緱鍒扳滀竴鍗佷簩浜誇笁鍗冨洓鐧句簲鍗佸叚涓囦竷鍗冨叓鐧句節鍗佲濄傚緢綆鍗曞惂錛
鍥1錛氶夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻
浜屻佸嚱鏁版洿姝ｆ硶
鍦‥xcel涓榪樻湁涓涓闅愬惈鐨勫嚱鏁板彲浠ヨВ鍐寵繖涓闂棰樸傛瘮濡侫1鍗曞厓鏍間腑鏄鏁板瓧鈥1234567890鈥濓紝閭ｄ箞鎴戜滑鍙瑕佸湪鍏跺畠鍗曞厓鏍間腑杈撳叆鍏寮忊=NUMBERSTRING(A1,2)鈥濄傚洖杞﹀悗灝卞彲浠ュ緱鍒扳滃９鎷捐窗浜垮弫浠熻倖浣頒紞鎷鵑檰涓囨煉浠熸崒浣扮帠鎷鋸濅簡銆傚傛灉鎴戜滑灝嗙浜屼釜鍙傛暟鈥2鈥濇敼鎴愨1鈥濇垨鑰呪3鈥濓紝閭ｄ箞鎴戜滑灝變細寰楀埌鈥滀竴鍗佷簩浜誇笁鍗冨洓鐧句簲鍗佸叚涓囦竷鍗冨叓鐧句節鍗佲濆拰鈥滀竴浜屼笁鍥涗簲鍏涓冨叓涔濃棆鈥濄
鍐嶅亣濡傝繖涓闂棰樹笉鏄鍙戠敓鍦‥xcel涓錛岃屾槸鍦╓ord琛ㄦ牸涓錛岄偅鍙堣ュ備綍澶勭悊鍛錛熷綋鐒訛紝涓縐嶉夋嫨鏄灝嗚〃鏍兼暟鎹澶嶅埗鍒癊xcel涓錛岃漿鎹㈠ソ浜嗕箣鍚庡啀澶嶅埗鍒癢ord琛ㄦ牸涓銆備笉榪囷紝鎴戜滑榪樺彲浠ラ夋嫨鐩存帴鍦╓ord涓瀹屾垚姝ら」浠誨姟鐨勩
閫変腑琛ㄦ牸涓鐨勬暟瀛椻1234567890鈥濓紝鐐瑰嚮鍔熻兘鍖衡滄彃鍏モ濋夐」鍗♀滅﹀彿鈥濆姛鑳界粍鈥滅紪鍙封濇寜閽錛屾墦寮鈥滅紪鍙封濆硅瘽妗嗐傚湪鈥滅紪鍙風被鍨嬧濆垪琛ㄤ腑閫夋嫨鈥滃９錛岃窗錛屽弫鈥濋」鐩錛屽傚浘2鎵紺猴紝紜瀹氬悗灝卞彲浠ュ緱鍒扳滃９鎷捐窗浜垮弫浠熻倖浣頒紞鎷鵑檰涓囨煉浠熸崒浣扮帠鎷鋸濅簡銆傚傛灉鍦ㄥ垪琛ㄤ腑閫変腑鈥滀竴錛屼簩錛屼笁鈥濋」鐩錛岄偅涔堝彲浠ュ緱鍒扳滀竴鍗佷簩浜誇笁鍗冨洓鐧句簲鍗佸叚涓囦竷鍗冨叓鐧句節鍗佲濄
鍥2錛氶夋嫨鈥滃９錛岃窗錛屽弫鈥濋」鐩
褰撶劧錛屽傛灉鎮ㄦ湁鍩熺殑緙栬緫鎰熷叴瓚ｇ殑璇濓紝榪樺彲浠ュ湪鍩熺﹀彿涓鐩存帴杈撳叆鍩熶唬鐮佲= 1234567890 * CHINESENUM3鈥濓紝鎴栤= 1234567890 * CHINESENUM2鈥濓紝鐒跺悗鎸変笅鈥淎lt+F9鈥濆揩鎹烽敭錛屽氨鍙浠ュ垎鍒寰楀埌鈥滀竴鍗佷簩浜誇笁鍗冨洓鐧句簲鍗佸叚涓囦竷鍗冨叓鐧句節鍗佲濇垨鈥滃９鎷捐窗浜垮弫浠熻倖浣頒紞鎷鵑檰涓囨煉浠熸崒浣扮帠鎷鋸濅簡銆傝佹槸杈撳叆鍩熶唬鐮佲= 1234567890 * CHINESENUM3鈥濓紝鎸変笅鈥溾淎lt+F9鈥濆揩鎹烽敭鈥濆氨鍙浠ュ緱鍒扳滀竴浜屼笁鍥涗簲鍏涓冨叓涔濃棆鈥濅簡銆備篃鎸虹畝鍗曠殑銆
2. 鎬庝箞鎶奺xcel涓灝忓啓鏁板瓧杞鎹涓哄ぇ鍐
鏈浜哄湪Excel浼氳″伐浣滃疄璺典腑錛岃捐′簡涓涓鏁板瓧灝忓啓閲戦濊漿鎹㈡眽瀛楀ぇ鍐欓噾棰濈殑鍏寮忥紝鍏寮忎粎500澶氫釜瀛楃︼紝涓浜烘劅瑙夎繕寰堟弧鎰忥紝鐜版嬁鍑烘潵渚涘ぇ瀹跺垎浜錛屼笉瓚充箣澶勶紝涔熻峰ぇ瀹朵笉鍚濊祼鏁欍
鍏寮忓備笅錛
=IF(ROUND(A1,2)=0,"",IF(A1<0錛"璐"錛"")&IF(ABS(A1)>=1,TEXT(INT(ROUND(ABS(A1),2)),"[dbnum2]"錛&"鍏"錛""錛&IF(VALUE(MID(RIGHT(TEXT((ABS(A1)*100+100),"###"),2),1,1))=0,IF(VALUE(RIGHT(TEXT(ABS(A1)*100,"###"),1))=0錛"鏁"錛孖F(ABS(A1)>=1錛"闆"錛""錛&TEXT(VALUE(RIGHT(TEXT(ABS(A1)*100,"###"),1)),"[dbnum2]"錛&"鍒"錛夛紝IF(VALUE(RIGHT(TEXT(ABS(A1)*100,"###"),1))=0,TEXT(VALUE(MID(RIGHT(TEXT((ABS(A1)*100+100),"###"),2),1,1)),"[dbnum2]"錛&"瑙掓暣"錛孴EXT(VALUE(MID(RIGHT(TEXT((ABS(A1)*100+100),"###"),2),1,1)),"[dbnum2]"錛&"瑙"&TEXT(VALUE(RIGHT(TEXT(ABS(A1)*100,"###"),1)),"[dbnum2]"錛&"鍒"錛夛級錛
鍏寮忎腑A1涓哄皬鍐欓噾棰濇墍鍦ㄥ崟鍏冩牸錛屽疄闄呬嬌鐢ㄤ腑鍙闇灝嗗叾鏇挎崲涓哄疄闄呭皬鍐欓噾棰濇墍鍦ㄥ崟鍏冩牸鍗沖彲錛岄潪甯告柟渚褲
鍏寮忓彲浠ュ規ｆ暟銆侀浂錛堟湰鍏寮忚漿鎹涓虹┖鐧斤紝涓庢敮紲ㄤ竴鑷達紝濡傞渶杞鎹涓衡滈浂鍏冩暣鈥濓紝鍙闇鍦ㄥ叕寮忕涓涓鍙屽紩鍙峰唴鍔犲叆鍗沖彲錛夈佽礋鏁幫紙浼氳℃暟鎹鏈夋椂涔熸秹鍙婂埌錛夊潎鍙榪涜岃漿鎹銆
鏈榪戱紝鍦ㄧ綉涓婄湅鍒伴珮鎵嬭捐＄殑鏇寸畝媧佺殑杞鎹㈠叕寮忥紝緙虹偣鏄鍙鑳芥妸鈥0鈥濊漿鎹涓虹┖鐧斤紝涓嶈兘杞鎹涓衡滈浂鍏冩暣鈥濓紝鍏寮忓備笅錛
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1),IF(A1>0錛岋紝"璐")&TEXT(INT(ABS(A1)+0.5%),"[dbnum2]G/閫氱敤鏍煎紡鍏冿紱錛"錛&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0瑙0鍒嗭紱錛涙暣"錛夛紝錛夛紝"闆惰"錛孖F(A1^2<1錛岋紝"闆")錛夛紝"闆跺垎"錛"鏁"錛
灝嗕互涓婁袱涓鍏寮忕粨鍚堜竴涓嬶紝杈懼埌鏃㈢畝鐭錛屽張鑳借揪鍒扳0鈥濈殑絀虹櫧鍜屸滈浂鍏冩暣鈥濅袱縐嶏紙鏍規嵁闇瑕佸彧鑳介夊叾涓涓縐嶏級杞鎹㈢粨鏋滅殑鐩鐨勩傚叕寮忓備笅錛
=IF(ROUND(A1,2)=0,"",IF(A1<0錛"璐"錛"")&IF(ABS(A1)>=1,TEXT(INT(ROUND(ABS(A1),2)),"[dbnum2]"錛&"鍏"錛""錛&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0瑙0鍒嗭紱錛涙暣"錛夛紝"闆惰"錛孖F(A1^2<1錛岋紝"闆")錛夛紝"闆跺垎"錛"鏁"錛夛級
3. 濡備綍鎶奺xcel琛ㄦ牸涓鐨勬暟瀛楀彉鎴愪腑鏂囧ぇ鍐欐暟瀛楅噾棰
B1=SUBSTITUTE(IF(A1,IF(A1<0錛"璐"錛)&TEXT(TRUNC(A1),"[dbnum2]g/閫氱敤鏍煎紡鍏冿紱[dbnum2]g/閫氱敤鏍煎紡鍏冿紱"錛&TEXT(RIGHT(RMB(A1),2),"[>9][dbnum2]0瑙0鍒嗭紱[>0][dbnum2]0瑙0鍒嗭紱鏁"錛夛紝"闆跺厓"錛夛紝"闆跺垎"錛岋級
4. 鍦‥xcel涓杈撳叆鏁板瓧鍚庡備綍浣垮畠鑷鍔ㄥ彉鎴愬ぇ鍐
浠Excel2016鐗堟湰涓轟緥錛屾搷浣滄柟娉曟ラゅ備笅錛
姝ラや竴銆佹墦寮闇瑕佺紪杈戠殑Excel琛ㄦ牸鏂囦歡銆
姝ラや簩銆侀変腑闇瑕佽緭鍏ユ暟瀛楃殑鍗曞厓鏍礆紝騫朵笖鐐瑰嚮榧犳爣鍙抽敭銆
姝ラや笁銆侀夋嫨鍙抽敭鑿滃崟涓鐨勨滆劇疆鍗曞厓鏍兼牸寮忊濋夐」銆
姝ラゅ洓銆佸湪寮瑰嚭鐨勨滆劇疆鍗曞厓鏍兼牸寮忊濆硅瘽妗嗕腑錛岄夋嫨鈥滃垎綾燴濅負鈥滅壒孌娾濓紝鈥滅被鍨嬧濅負鈥滀腑鏂囧ぇ鍐欐暟瀛椻濄
姝ラや簲銆佽劇疆瀹屾瘯錛屽湪鍗曞厓鏍煎唴杈撳叆鏁板瓧鑷鍔ㄨ漿鎹涓哄ぇ鍐欐暟瀛椼
5. excel琛ㄦ牸鎬庝箞璁劇疆灝忓啓鏁板瓧杞鎹㈠ぇ鍐
Excel琛ㄦ牸涓灝忓啓鏁板瓧杞鎹涓哄ぇ鍐欑殑鏂規硶錛
1銆佸湪璁＄畻鏈烘岄潰宸﹂敭鍙屽嚮Excel2003鍥炬爣灝嗗叾鎵撳紑榪愯屻
2銆佸湪鎵撳紑鐨凟xcel琛ㄦ牸鐨勬煇涓鍗曞厓鏍艱緭鍏ュ皬鍐欐暟瀛椼
3銆侀変腑杈撳叆灝忓啓鏁板瓧鐨勫崟鍏冩牸錛岀劧鍚庣偣鍑婚紶鏍囧彸閿錛屾墦寮鐨勮彍鍗曞垪琛ㄤ腑閫夋嫨鈥滆劇疆鍗曞厓鏍兼牸寮忊濋夐」銆
4銆佺偣鍑昏劇疆鍗曞厓鏍兼牸寮忛夐」鍚庯紝榪欎釜鏃跺欎細鎵撳紑鈥滃崟鍏冩牸鏍煎紡鈥濆硅瘽紿楀彛銆
5銆佸湪鍗曞厓鏍兼牸寮忓硅瘽妗嗕腑鐨勨滄暟瀛椻濋夐」鍗＄殑鈥滃垎綾燴濇嗕腑閫夋嫨鈥滅壒孌娾濋夐」銆傚湪鐗規畩鐨勭被鍨嬫嗕腑閫夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻濓紝鐒跺悗鐐瑰嚮鈥滅『瀹氣濇寜閽銆傚傚浘鎵紺猴紱
6銆佽劇疆瀹屾垚鍚庯紝榪斿洖鍒癊xcel琛ㄦ牸緙栬緫紿楀彛錛屽崟鍏冩牸鐨勫皬鍐欐暟瀛楀凡緇忚漿鎹㈡垚浜嗗ぇ鍐欓噾棰濄傞偅涔堬紝涓嬫″氨涓嶇敤姣忔¤緭鍏ュぇ鍐欒繖涔堣垂浜嬩簡銆
『肆』 excel鏁板瓧杞鎹㈡垚澶у啓閲戦漞xcel鏁板瓧杞鎹㈡垚澶у啓閲戦濆叕寮
鍏充簬excel鏁板瓧杞鎹㈡垚澶у啓閲戦濓紝excel鏁板瓧杞鎹㈡垚澶у啓閲戦濆叕寮忚繖涓寰堝氫漢榪樹笉鐭ラ亾錛屼粖澶╂潵涓哄ぇ瀹惰В絳斾互涓婄殑闂棰橈紝鐜板湪璁╂垜浠涓璧鋒潵鐪嬬湅鍚э紒
1銆佸伐鍏鳳細2010鐗坋xcel鍏堟墦寮excel銆
2銆佷互涓嬪浘涓轟緥銆
3銆侀渶瑕佸皢A1鍗曞厓鏍間腑鐨勬暟瀛楄漿鍖栨垚涓鏂囧ぇ鍐欓噾棰濇牸寮忓苟鍦˙1鍗曞厓鏍間腑鏄劇ず緇撴灉錛2銆侀変腑B1鍗曞厓鏍煎苟杈撳叆鍏寮忊=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/閫氱敤鏍煎紡鍒"),"闆惰","闆"),"闆跺垎","")鈥濓紱3銆佹寜涓嬪洖杞﹂敭鍚庡氨鍙浠ュ湪B1鍗曞厓鏍間腑寰楀嚭緇撴灉浜嗐