User Login

Help Community Login:

Excel Tips & Tricks - Use Units of Measure Without Changing Numbers to Text

2 replies [Last post]
missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3110
Drops: 3812
Mood: Weird

To display a unit of measure (eg. lb., kg., km., in., etc...) in a cell without changing the number to text, you can create a custom number format. Very simple!

  1. Select the cells containing the numbers

  2. In Excel 2000-2003, from the Format menu select Cells. In Excel 2007, 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 and type the unit of measure enclosed in quotes (e.g. " km." ) to the right of the number format

Format cells with measurements in Excel 2000 - 2015
I Averaged: 4 | 3 votes

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Aprill's picture
Aprill
Re: Excel Tips & Tricks - Use Units of Measure Without ...

Awsome. Thank you!

jasonmnorman1's picture
jasonmnorman1
Re: Excel Tips & Tricks - Use Units of Measure Without ...

Thanks for this.
Is it possible to show meters (m) when under 1 km? I have been trying to work this out with g & kg. I generate all numbers in grams but would like to show something similar to: 45kg 500g instead of 45500g. I managed to make this work by entering something along the lines of "#### "kg", ### "g"" but then I end up with and even kg still showing 000g, which largely defeats the purpose.

Thanks again!

Who's New

Iris's picture
makay Das's picture
TinyBoxTim's picture
jessicapatel123's picture
VICKSINLGA's picture
HaileyMoore21's picture
HaileyMoore's picture
richjobe's picture
to-cljb's picture
Csabrina's picture
uthararaj's picture
revinluke's picture
bestclash's picture
rockyridego's picture
barackobama's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2016
TOS | Privacy Policy