資源描述：
《如何把excel日期格式轉(zhuǎn)換成文本日期格式》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、如何把excel日期格式轉(zhuǎn)換成文本日期格式導(dǎo)入表要統(tǒng)一的日期格式是yyyy-mm-dd,單完格格式必須為文本格式。方法如下：選中要更改格式這一欄，然后執(zhí)行數(shù)據(jù)--分列。在彈出的窗口中選中（分隔符號）這一欄。he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicat
2、ed,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine然后點(diǎn)擊下一部，在彈出的窗口中選中（tab鍵）。再點(diǎn)擊下一步。這一步很關(guān)鍵（在列數(shù)據(jù)格式中選中“日期YMD”格式）。然后點(diǎn)擊完成。he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificwork
3、treatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine這時在表格出現(xiàn)的格式是YYYY-M-D，然后再選中日期這一欄，執(zhí)行自定義格式y(tǒng)yyy－mm－dd?？纯唇Y(jié)果吧，是不是已經(jīng)達(dá)到效果了呢。注：我使用是office2003.????上面這些步驟主要是修改日期
4、格式，現(xiàn)在我們還要將日期格式轉(zhuǎn)化為文本格式。第一步，把電子表格中日期數(shù)據(jù)列復(fù)制到word中，在右下方的提示中選擇僅保留文本，或者選擇性粘貼文本。第二步，選定復(fù)制文本轉(zhuǎn)換為表格，文本分隔位置為段落標(biāo)記，復(fù)制word中表格。he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistooco
5、mplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine第三步，在excel中，將相應(yīng)列轉(zhuǎn)為文本格式，然后選擇性粘貼——文本。得以成功轉(zhuǎn)換。he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedep
6、loyment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine
