How WPS turns numbers into money
To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:
-
select the cell to be set, right-click to select the cell format
-
to open the cell Format dialog box, click the number tab (the general default number tab is activated)
-
to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of
< / OL >
as shown in the following figure:
word,
but you can use macros. I'm not good at macros. Please try to extract other people's macros; You can use the following macro. You need to specify the shortcut key
sub temp()
selection. Text = format (selection. Text, & quot; # #, # # 00") < br />
End Sub ' Do you want to name it by yourself?
in Excel, there are cell options (Ctrl + 1) in the format form, click the tab, and currency and accounting specific currency input forms are available in the number part.
-
select the number range to be changed
-
right click to set the cell format, as shown in the figure below
-
-
select "number" -- "numerical value", and set it as you want
Convert to a table. In the insert table tool, the text is converted to a table
then, it to the WPS table, and it's easy to use sorting or filtering
after separation, it back from the table. Also use the table tool to convert the table to text
for more WPS office software tutorials, please visit: http://bbs.wps.cn perhaps http://e.weibo.com/wpswfw
right click to set the cell format, as shown in the figure below
select "number" -- "numerical value", and set it as you want
Here is an operation flow of word number to currency format:
required materials: this method is only applicable to the numbers in the table
1. As shown in the figure below, the numbers are listed on the left. Click the first cell on the top right to enter the "layout" menu