Office Watch

Office 2013

Office Mobile / iPad

Office 2010

Office 2007

Office 2003

Office XP

Office for Mere Mortals

Access

Email

Buying Office

Office 365

Winks

Office News Wire

Join us!

Our Ebooks

Mobile | PDA

RSS


Search

Command Finder


Microsoft Office Bookshop

About

Home




Excel CONVERT measurement list

A full list of the measurements and multiplier prefixes available for Excel's CONVERT function.

by Office for Mere Mortals

Bookmark and Share

  | Mobile | click for more article services     


This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.

Measure Formula Abbrev. (case sensitive) Inbuilt / Multiplier

Distance

   
Angstrom "ang" Inbuilt
Foot "ft" Inbuilt
Inch "in" Inbuilt
Meter "m" Inbuilt
Statute mile "mi" Inbuilt
Nautical mile "Nmi" Inbuilt
Pica "pica" Inbuilt
Yard "yd" Inbuilt
Kilometre "km" Multiplier
Millimetre "mm" Multiplier
Centimetre "cm" Multiplier

Weight / Mass

   
Gram "g" Inbuilt
Kilogram "kg" Multiplier
Milligram "mg" Multiplier
Pound mass (avoirdupois) "lbm" Inbuilt
Ounce mass (avoirdupois) "ozm" Inbuilt
Slug "sg" Inbuilt
U (atomic mass unit) "u" Inbuilt

Temperature

   
Degree Celsius "C" (or "cel") Inbuilt
Degree Fahrenheit "F" (or "fah") Inbuilt
Kelvin "K" (or "kel") Inbuilt

Time

   
Day "day" Inbuilt
Hour "hr" Inbuilt
Minute "mn" Inbuilt
Second "sec" Inbuilt
Year "yr" Inbuilt

Energy

   
BTU "BTU" (or "btu") Inbuilt
Foot-pound "flb" Inbuilt

Liquid Measure

   
Cup "cup" Inbuilt
Gallon "gal" Inbuilt
Liter "l" (or "lt") Inbuilt
Milliliter "ml" Multiplier
Fluid ounce "oz" Inbuilt
U.S. pint "pt" (or "us_pt") Inbuilt
Quart "qt" Inbuilt
Tablespoon "tbs" Inbuilt
Teaspoon "tsp" Inbuilt
U.K. pint "uk_pt" Inbuilt

Magnetism

   
Gauss "ga" Inbuilt
Tesla "T" Inbuilt

Power

   
Horsepower "HP" (or "h") Inbuilt
Watt "W" (or "w") Inbuilt

Multipliers

Prefix these to some abbreviations to make other measurement units. For example 'k' for kilo plus 'g' for gram = 'kg' for kilogram.  The more commonly used ones are in bold.

exa 1.00E+18 "E"
peta 1.00E+15 "P"
tera 1.00E+12 "T"
giga 1.00E+09 "G"
mega 1.00E+06 "M"
kilo 1.00E+03 "k"
hecto 1.00E+02 "h"
dekao 1.00E+01 "e"
deci 1.00E-01 "d"
centi 1.00E-02 "c"
milli 1.00E-03 "m"
micro 1.00E-06 "u"
nano 1.00E-09 "n"
pico 1.00E-12 "p"
femto 1.00E-15 "f"
atto 1.00E-18 "a"

Article posted: Sunday, 27 November 2011

there's more ...

If you liked this article you'll LOVE our new ebooks.

Office 2013: the real startup guide

OFFICE 2013: the real startup guide Everything you need to know about Office 2013 but Microsoft won't tell you.

How to save money, install, configure and use the new features in Office 2013.  Get it today - click here.

Windows 8 for Microsoft Office users

Windows 8 for Microsoft Office users A practical guide the new, changed and unfamiliar in Windows 8

A focused and unvarnished look at Windows 8, especially written for the many people who use Microsoft Office  Get it today - click here.

ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox

100+ pages of practical tips and help to streamline, automate and search your Inbox.  Get more than you ever thought possible from Outlook.  Read it today - click here.

More from Office Watch:



Article Services sponsored by: Office Watch Ebooks - available now to download and read today.
RSS feed for this category Subscribe

Translate | Mobile | Links
 Add to: Bookmarks | | DiggThis | Yahoo! My Web


New & Popular
» Simple and useful PivotTables
» Microsoft’s commitment to Office beyond Windows
» Which character code is that?
» How Word’s grammar check can let you down
» One Terabyte of OneDrive is here
» What is Microsoft Delve?


Office Watch, Office for Mere Mortals, Access Watch and all titles used within the publications are Copyright © 1996-2014 Office Watch.
Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint and doubtless many other names are registered trademarks of Microsoft Corporation.

Search  |  Sitemap |  Popular Topics | Privacy Statement |  Advertising |  Twitter |  Feedback / Contact Us
Office Watch is definitely not affiliated with Microsoft - and that's just one reason why we are so useful to Microsoft Office users around the world J (Erko).