MS Excel Custom Formatting - Show Units Of Measure Without Changing Your Numbers To Text

Without Changing Your Numbers To Text Show Units Of Measure in MS Excel with Example.

Many of you don't know that you can display a unit of measure (eg. lb., kg., km., in., etc...) in a cell of MS Excel worksheet without changing your numbers to text, so you can still use them in calculations?

It is not a very tough work, it's very easy! All you need to do is create a Custom Number Format.

To Add Measure Units in your MS Excel worksheet cell without changing the format of your cell from Number to Text follow the given below steps:-

1) Select the cells which containing the numbers;

2) On the Home tab, click the small dialog launcher arrow on the bottom right corner of the Number group;

3) In the Format Cells dialog on the Number tab click Custom in the Category list;

4) In the Type field, select a number format for your cells;

5) Type the unit of measure enclosed in quotes (e.g. " km." ) to the right of the number format in the Type field.

Format Cells as Number with Text (Measure Units) in Excel

Now when you look at the numbers in your MS Excel worksheet, they will display the unit of measure, but in the formula bar you can easily see that they are still numbers that you can use in calculations.