User Login

Help Community Login:

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

missb's picture
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3111
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 2003

I Averaged: 4 | 3 votes

Who's New

XLady1738SavageX's picture
shyrellware's picture
lilmystere's picture
zaiishay's picture
CaveLion's picture
doublethread's picture
Aj1998Jc's picture
lulu's picture
iflc's picture
dankerz95's picture
nilchowdhury's picture
gavin's picture
taurus2640's picture
Calvintbeoiha's picture
jonathon_14's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2015
TOS | Privacy Policy