wps表格怎樣將數字轉換成大寫

1. wps表格中中文數字怎麼轉換為阿拉伯數字

=LOOKUP(1,0/(B1=TEXT(ROW(1:10000)-1,"[dbnum2]")),ROW(1:10000)-1)

這里是借用行號設置的公式，所以數值不能太大，不能超過所用版本的最大行號，此處用的10000，可用於替換0~9999（零~玖仟玖佰玖拾玖）。

2. 怎麼把數字變為大寫，WPS表格中

• 可以通過wps單元格格式中特殊命令來實現。

• 第一步，選擇想要轉換為大寫的數字單元格，右鍵選擇設置單元格格式
  

  

3. wps表格如何把數字變成中文大寫

• 打開【WPS表格】

  

4. 轉換在WPS表格中，如何輸入阿拉伯數字後轉換為人民幣大寫我用系統裡面的特殊格式，人民幣大寫，30

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1,2),TEXT(A1,";負")&TEXT(INT(ABS(A1)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A1^2<1,,"零")),"萬",IF(AND(MOD(ABS(A1%),1000)<100,MOD(ABS(A1%),1000)>=10),"萬零","萬")),"零分","整")
這是假設你的數據在A1單元格，可自行修改。

5. wps表格里的數字如何轉為人民幣大寫形式

單元格格式修改

6. wps表格怎樣數字轉大寫

右鍵 設置單元格格式 即可

7. wps怎麼將數字轉換成大寫數字

以WPS 2019版為例

1.在文檔中選中數字，依次點擊「插入」--->「插入數字」

8. wps如何元變成萬元之後再使數字變成小數點後兩位

一位小夥伴詢問在電子表格中輸入數字，比如12345為何會變成123.45，只有輸入12345.才顯示為12345。單元格格式不管是設置為常規還是數字都是一樣。

遇到這種問題，就是因為wps表格小數點設置出現錯誤。只需要按照下面的方法設置：WPS表格——工具——選項——編輯，取消勾選「自動設置小數點」即可。

下面，小編給夥伴用動畫演示一下WPS表格數字後面小數點的設置和取消操作。

是不是簡單，只要找到隱含參數設置的位置，勾選或者取消就好了。
數字變中文大小寫：
當我在編輯的過程中需要將大量的數字批量地變成中文小寫的時候怎麼處理呢？比如「12345」，我要變為「一萬二千三百四十五」或者是「壹萬貳仟叄佰肆拾伍」！

1、首先我們先選中需要變化的數字；然後滑鼠右鍵選擇「設置單元格格式」；

2、然後在彈出的窗口中選擇「特殊」，再點擊「中文小寫數字」就ok

如果是變為中文大寫或者是人民幣大寫時，就只需點擊上圖中的「中文大寫數字」或者是「人民幣大寫」就ok了！

這是批量處理表格的快捷方法，下面小編推薦一個在對單元格編輯的輸入中文大小寫的快捷方法：

其實在大部分主流的輸入法軟體中有編輯中文大小寫的快速方法（利用字母v協助）：

比如我們在中文輸入的情況下先輸入字母「v」，然後直接輸入數字就可以出現這些大小寫了。比如：我輸入「v12345」，在下面就出現了對應的大小寫。

提醒一下：（1）要在中文輸入法的情況才有效；（2）輸入數字後再輸入一個小數點就可以更快的出現人民幣大寫了（但只能精確到分，也就是說如果小數點後超過兩位，則無法打出人民幣大寫了哦，比如我們輸入「v2344.234」是無法顯示大寫的）。

數字變日期時間：
在我們使用WPS輸入日期的時候，或者批量將數字變為日期的時候常常不知道怎麼處理，甚至經常出問題。下面我就分享一下：

1、首先我們先選擇需要變化的那一列數據，注意是要選擇連續的一列區域哦。然後點擊「數據」菜單欄；

2、然後就可以彈出一個窗口了，再直接點擊「下一步」，接著同樣不用管點擊「下一步」；

3、在第三步的時候選擇「日期」，然後點擊旁邊的「年月日格式」。比如我的數據是年，月，日；那選擇的格式是「YMD」。最後點擊「完成」就ok了！

提醒一下：（1）、要選中一列中連續的區域；（2）、你的數字格式必須要是8位數字哦！

9. 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"))