Use Excel’s Custom Number Formats to Display Numbers with their Units of Measurement Alongside… e.g 50 Kg

If you have a column of data that you want to show as a measurement unit such as Km, Kg, Lbs and so on, you can set up a custom format so that you don’t have to enter the measurement unit every time. Instead, Excel will show the unit of measure in the cell along side the number. It also helps if you need to reference the values in formulae because Excel will not allow you to sum values such as 50 kg.

Watch this short video on my YouTube channel to see how it’s done using 2 examples including kilometres and degrees.

See you again soon, please comment and share if you found useful!
Anita Lund
www.trainers-direct.com.au  Sydney
www.stormtraining.com UK