How to add units in excel

How to automatically add "10,000 yuan", "kg", "jin/yuan", etc. as units after entering numbers in Excel? How to add units without affecting the calculation?

#How to add units in excel?

How to add excel units:

First select the cell where you want to set the unit, right-click, and click "Format Cells".

Then select "Custom", enter "0.00 catties" in "Type", and click "OK".

Similarly, select the cells in the second column and set the format to "0.0000 "jin/yuan"".

Note that the "jin/yuan" here must be enclosed in double quotes in English half-width notation, otherwise the following error will occur.

Similarly, the unit of amount is also set in this way.

#When setting the unit, if you want to keep a few decimal places, enter a few "0"s after the decimal point. As shown in the figure below, setting it up in this way will not affect your calculations at all.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column to learn!

The above is the detailed content of How to add units in excel. For more information, please follow other related articles on the PHP Chinese website!