貼上 Excel 時,前方有零文字,會變數字,零會不見
因為 Excel 會將都是數字的文字貼上時當數字格式處理,如果要保留文字格式,我使用方法如下(不知有沒有更好)
將要貼上的 Excel 儲存格改成文字格式,再貼上時先按右鍵,選擇右邊圖式(符合目的格式設定)就可以保留零,因為我們已經先將格式改成文字
說明檔 : Excel.docx
小豬的備忘錄,對錯完全不負責
因為 Excel 會將都是數字的文字貼上時當數字格式處理,如果要保留文字格式,我使用方法如下(不知有沒有更好)
將要貼上的 Excel 儲存格改成文字格式,再貼上時先按右鍵,選擇右邊圖式(符合目的格式設定)就可以保留零,因為我們已經先將格式改成文字
說明檔 : Excel.docx
迴響
貼上 Excel 時,前方有零文字,會變數字,零會不見 | 豬窩
I go tto ssee evfery daay sime weeb pages aand sies too read
content, but his website presents featurre bazsed content.
貼上 Excel 時,前方有零文字,會變數字,零會不見 | 豬窩
Hi! Do you usse Twitter? I'd likje to follow yyou iif that would be okay.
I'm dedfinitely enjoying you blog and look forward too nnew
updates.
貼上 Excel 時,前方有零文字,會變數字,零會不見 | 豬窩
I don't even knbow hhow I stoppd up here, but I thought thos submit waas great.
I don't recogynise whoo yoou mght be bbut definiteloy yoou aare oing to a ffamous blogger when you aren't already.
Cheers!
貼上 Excel 時,前方有零文字,會變數字,零會不見 | 豬窩
Thiis poet presents clear idea iin support off tthe new visitors of blogging, thzt geninely how too do blogginbg
and site-building.
貼上 Excel 時,前方有零文字,會變數字,零會不見 | 豬窩
Aw, this waas ann exceptionally good post. Finding
thee time and actual effort to proxuce a great
article… but what caan I say… I put things ooff a lott and never seem too
get nearly anythkng done.