How to classify numbers into currency
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down
1. First, you need to open the Excel software in the computer, open the data, select the cell, and right-click the cell
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.
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
After the "bile replacement revolution", Midea air energy water heater recently launched a six-year warranty service, which attracted the attention of the instry. This service is the first time. It is worth mentioning that Midea's home central air conditioning has also announced in a high profile that it has entered the era of "6-year warranty"
as a leading brand in the instry, Midea advocates 6-year free repair service for a full range of household central air conditioners and air energy water heaters from the fundamental interests of consumers, which eliminates the worries of users and guarantees the quality of Midea's procts. As we all know, with the improvement of people's living standards and the pursuit of low-carbon life, healthy, safe, energy-saving and comfortable air energy water heaters have become the most popular household appliances in the market, and their sales are rising. However, the warranty period of air energy water heaters on the market is generally 1-3 years
the launch of Midea's 6-year warranty service for air energy water heaters is obviously "well thought out". From 2008 to 2013, Midea air energy water heater has been leading the domestic and foreign sales for six consecutive years, and has always occupied the top position in the instry. The reason why Midea dare to make such a big commitment lies in its high confidence in the exquisite quality of its procts. According to the introction, the water tank is the easy problem part of the air energy water heater, and the water tank of the procts on the market is generally made of stainless steel
as early as 2012, Midea took the lead in introcing the "e + blue drill liner" technology in the instry. It adopts the BTC steel plate specially supplied by Baosteel, the top liner coating of ferro company of the United States, and the 850 ℃ high temperature baking process. It has undergone 800000 times of life test and 480 hours of acid resistance test, with a service life of more than 15 years, reaching the top quality in the instry, It has obtained the high trust of domestic and foreign consumers, and the market response is good. In June this year, Midea announced to the whole instry in a high-profile manner that all stainless steel tanks would be abandoned, and all air water heater tank tanks would be upgraded to "e + Blue Diamond"
The steps of setting currency style in Excel are as follows:
prepare materials: Excel software, computer
1. Open the Excel software and open the excel table to be edited, as shown in the figure:
select the number of decimal places in the red circle