:Table special cell format batch conversion of units of 10,000 yuan-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Table special cell format batch conversion of units of 10,000 yuan

Table special cell format batch conversion of units of 10,000 yuan

Author: daogeziyuan • • Table skills • Views 671
  • Image and text skills


When we use WPS forms for office work, we often encounter the need to enter values ​​in units of ten thousand yuan, one million yuan, etc.

So how to quickly convert ordinary numbers into special formats such as this?


0.gif

分界线.png

▪Taking this table as an example, suppose we want to convert the numbers in this column into values ​​in units of "ten thousand yuan".

Select the cell range, right-click "Format Cells", its shortcut key is Ctrl+1.

In the pop-up "Format Cells" dialog box, select Number-Special.

Select "Unit: 10,000 yuan" in the type, and select "10,000 yuan" in the unit list on the right.

Click OK to quickly convert this column of numbers into a value in "ten thousand yuan".


1.gif


▪In addition, we can also convert numbers into Chinese lowercase numbers;


2.gif


Chinese uppercase numbers;


3.gif


RMB in capital letters;


4.gif


Numbers with positive and negative signs.


5.gif

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-te-shu-dan-yuan-ge-ge-shi-pi-liang-zhuan-huan-wan-yuan-dan-wei.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 智-佳艺数码 Columnist
48 196
single-end

Related Suggestion