How to convert unit into ten thousand yuan in excel

First open the excel form and enter some numbers.

Input formula =text=TEXT(G2,"0.00")&"10,000 yuan")

Press After pressing Enter, the result appears

Finally hold down ctrl enter to update all data

If the unit is added to the US dollar, the suffix is For every hour, the formula is as follows: =TEXT(G2,"$0.00")&"Hourly"

All the results appear after holding down the Enter key.

Recommended related tutorials: excel tutorial

The above is the detailed content of How to convert unit into ten thousand yuan in excel. For more information, please follow other related articles on the PHP Chinese website!