Use Excel’s Custom Number Formats to Display Numbers with their Units of Measurement Alongside… e.g 50 Kg
When working with numerical data in Excel, especially measurements like kilograms, kilometres, or degrees, it’s often helpful to display units directly within the cell for clarity and consistency. Rather than typing “kg” or “km” manually each time, you can use Excel’s custom number formatting to automatically show the unit next to the number. This not only keeps your spreadsheet looking clean and professional, but also ensures the values remain fully functional in formulas and calculations. In this article, you’ll learn how to apply custom number formats to streamline your workflow and avoid common errors—plus, there’s a quick video tutorial to guide you through real examples.
How to Create a Custom Number Format in Excel for Kms, Degrees and more…
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!
Visit our Excel training page or one on one training if you want to increase your Excel skills, take our excel tests!
Anita Lund
www.trainers-direct.com.au Sydney
0 Comments