Display Units as Custom Formats
When doing calculations in Excel, you often have to deal with units. One way to manage this is to create a custom format for each unit.
To do this, select your data, and choose Format Cells > Number > Custom. Then, add the text for the unit to the end of your custom format.
This approach ensures that the units don't interfere with any of your formulas or calculations. Perfect!