wps標尺怎樣由數字轉字母

① 在excel表中如何將行標由數字改為字母

1、首先需要打開Excel的軟體，如圖所示，可以看到上面的行標現在是數字。

② wps表格文件裡面的阿拉伯數字怎麼能自動轉換成英文金額呢

有兩種方法可以把阿拉伯數字轉換成英文。

一、用公式比較復雜

="US DOLLARS "&UPPER(TRIM(IF(VALUE(RIGHT(INT(A1/1000000000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" billion ")&IF(VALUE(RIGHT(INT(A1/1000000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" million ")&IF(VALUE(RIGHT(INT(A1/1000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" thousand ")&LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&IF(VALUE(RIGHT(TEXT(A1,"0.00"),2))=0,""," AND CENTS "&IF(VALUE(RIGHT(TEXT(A1,"0.00"),2))<20,LOOKUP(VALUE(RIGHT(TEXT(A1,"0.00"),2)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19;"","one","two","three","four","five","six","seven","eight","nine","ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(LEFT(RIGHT(TEXT(A1,"0.00"),2),1)),{2,3,4,5,6,7,8,9;"twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"})&" "&LOOKUP(VALUE(RIGHT(TEXT(A1,"0.00"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})))&" ONLY"))

③ wps表格打出的數字變成字母

在Excel和WPS表格裡面，當輸入的數據可以是文本格式、也可以是日期格式時，程序會優先選擇「日期」格式。
你上面的「Aug-13」不是「數字變成字母」，而是日期的英語習慣寫法。
Aug——英語八月「August」縮寫。
要保留「2013-8」，可在輸入前加半形單引號變成文本樣式，或先設置該單元格格式為「文本」。
直觀顯示「2013-8」也行，改單元格格式為日期（直觀顯示的，在其編輯欄裡面是2013－8－1，明白即可）：
選定單元格——右鍵——設置單元格格式——數字——自定義——類型：
yyyy-m
——確定。

④ WPS表格中如何將數字列與字母列轉換

選擇字母行（數字列），選擇剪切，右擊在粘貼的地方，選擇「選擇性粘貼」，在打開的對話框中選擇「轉置」，確定即可。

論文排版、模版下載、論文遇到難題，解決方法：http://docer.wps.cn/zt/lunwen?from=qyzd
更多WPS辦公軟體教程，請訪問：http://bbs.wps.cn或者http://e.weibo.com/wpswfw

⑤ WPS表格里0~9的數字怎樣轉換成a~j的字母

Ctrl+H 替換吧。
替換9次-.-。雖然麻煩了點，但是很快！

⑥ WPS表格輸入的數字變成字母怎麼辦

第一步：選擇你要調整的表格，或全選或指定選你要調的那幾欄，接著點擊右鍵進入「設置單元格格式」，進去後你會看到「數字、對齊、字體、邊框、圖案、保護」請在「數字」列表下操作（以下二、三步均在此操作）。
第二步：進入「數值」項進行設置，將右側顯示的「小數位數」旁邊那個數值設置為「0」，接著點擊下面「確認」。
第三步：依然在第一步的數字列表下操作，點擊倒數第三個「文本」，接著點下面「確認」。
第四步：退出設置，大功告成！

我看你這么久都沒選擇一個答案，相信這個說的很清楚，如果可以的話，就選擇為最佳答案哈！希望其他有同樣疑問的朋友看到也能得到幫助。

⑦ WPS數字轉換為字母

=CHAR(64+CELL("col"))
=CHAR(64+COLUMN())

⑧ 如何在WPS中把數字直接變成字母

盡管在使用WPS編輯論文時，WPS會在默認的情況下自動將漢字設為「宋體」，將英文字母設為「Times New Roman」

但有些物理量的符號或單位卻是用希臘字母表示的，如密度的符號ρ，電阻的單位Ω等，這些內容在默認情況下卻被設為「宋體」

文章編輯完成後，如果一點點查找後逐個修改，既麻煩又容易發生遺漏，如果通過查找來進行批量設置，則會簡單的多。方法如下：
按下組合鍵，調出「查找和替換」對話框，切換到「智能ABC輸入法」後，在輸入法窗口的鍵盤圖標上單擊滑鼠右鍵，在彈出的快捷菜單中單擊「希臘字母」命令，

在屏幕右下方就會出現一個軟鍵盤，

我們可以利用它迅速而准確地輸入希臘字母。在「查找內容」選項右側的文本框中輸入「[Α-ω]」後，勾選「突出顯示所有在該范圍找到的項目」和「搜索選項」標簽下的「使用通配符」選項後，

單擊「查找全部」按鈕，即可選中文章中所有希臘字母，將他們的字體統一設為「Times New Roman」即可。

⑨ 怎麼樣把WPS表格裡面批量的數字替換成字母

這種批量操作的你通過使用「無敵點擊狗」軟體就能輕松搞定的，包括各類表單輸入，文件提取錄入等，在無敵點擊狗軟體里都支持。當然了，你也可以自由發揮編排，無敵點擊狗具有靈活多樣的點擊按鍵，滑鼠動作，文件操作任務。

⑩ wps表格 數字 轉換 字母

=SUBSTITUTE(ADDRESS(1,A1,4),1,"")