資源描述:
《在excel 里將數(shù)字變成金額大寫》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、在EXCEL里將數(shù)字變成金額大寫我和其他人一樣,只知道WORD里可以將數(shù)字轉(zhuǎn)換成中文大寫,一次偶然的機會讓我也發(fā)現(xiàn)了EXCEL里面原來也可以。首先像往常一樣輸入數(shù)字在表格的一格里面,然后右鍵單擊此格----看下拉列表的<設(shè)置單元格格式>在<設(shè)置單元格格式>里找到自定義,《通用格式“圓”整》he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktre
2、atswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine單擊確定。he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderst
3、andingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine看下圖表,之前的數(shù)字即變成了人民幣金額顯示。就這么簡單。哈哈!he"governi
4、ngforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.
5、Forexample,noncoalmine