Convert numbers to Chinese strings.
Grammar
NUMBERSTRING(VALUE,TYPE)
value: The number to be converted.
type: the type of result returned.
Description
This function only supports positive integers and does not support numbers with decimals.
In life and work, we often encounter the need to convert Arabic numerals into Chinese upper and lower case.
The NumberString function is involved here.
Let me show you the actual operation to help you understand this function.
First open the form and place the cursor at D3.
Click Insert Function-Text-NumberString Function, and a dialog box will pop up.
"Value" is the value converted into Chinese characters, enter C3.
"Options" can be filled in with 1, 2, or 3.
1 is converted into lower case Chinese characters, 2 is converted into upper case Chinese characters, 3 is converted into Chinese characters for reading and writing,
Enter 1 and click OK to convert the number into lowercase Chinese characters.
Place the cursor in the lower right corner of D3 and form a cross-shaped drop-down to fill in the formula to perform batch conversion.
Similarly, position the cursor at E3 and insert the NumberString function.
Enter C3 in "Value" and 2 in "Option".
Click OK to convert the numbers into uppercase Chinese characters.
Position the cursor at F3 and insert the NumberString function.
Enter C3 in "Value" and 3 in "Option".
Click OK to convert the numbers into Chinese characters for reading and writing.
评论列表(196条)
测试