User Login

Help Community Login:

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

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 | 1 vote

Who's New

djhart12's picture
JohnCruz's picture
mimimimi's picture
pepelepew696's picture
majsan's picture
paleta's picture
jayeshprajapati's picture
selva's picture
lauraah50324's picture
sourav's picture
pinggolfswing's picture
dev25365's picture
sexybabygirl_7's picture
michellesirimarco's picture
diablopink's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2014
TOS | Privacy Policy