Measurement Converter Smart Tag / Action

Switch from imperial/metric from inside Word 2002/XP to Word 2010.

The Measurement Converter is a Smart Tag (Action in Word 2010) that can change your text from imperial/US to metric or vice-versa.

As the name suggests converts measurement units used in the Word document for example convert miles to kilometers or kg to pounds. Apart from converting standard units that is already defined you can add new units to the converter and edit the conversion rules of existing units.

Measurement converter can also be used in Outlook when you use your email editor as Word.


Installation

Measurement Converter is supplied with Office 2007 and Office 2010 so it should already be in your Smart Tags (Actions) list.

For Office 2003 and Office XP go to Microsoft.


Activate Measurement Converter

There are few ways to activate the measurement converter smart tag. You can do it directly by selecting the text in the document or activate it in the Options menu. For the first method select the text in the document whose unit you want to convert. Text can be in any format for the tag to work. There is a specific syntax for it. For example for the text 60kg you will not be able to use the measurement converter smart tag. The correct text should be 60 kg. So you must provide a space before the unit name. Measurement converter supports and recognizes decimal places in the number but the length of the number should not exceed 12 digits.

Once you select the number to convert in the document right click and select Additional Actions | Options.

Activate MC.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

AutoCorrect window will pop open which displays all the available smart tags. Here select the option “Measurement Converter” and click on OK button.

Autocorrect window.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

Now select the number again and right click and select Additional Actions. Here you can see the converted result for the selected number i.e. 2333.4 miles is converted to 3755.24 km.

MC window.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

If there is another related unit then even the conversion result for that will also be shown. For example as shown in the below screenshot for 88 kg the result is converted to two different units i.e. pounds and lbs.

Measurement Converter sample.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

For another way of activating the measurement converter smart tag, click on File | Options.

In the Word Options window that pops open select the option Proofing and click on the button “AutoCorrect Options”.

Autocorrect Options.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

AutoCorrect window pops open. Here under the Actions tab select the “Measurement Converter” action and click on OK button. You can now make use of this smart tag as explained above.

Select Autocorrect option.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

There is also another way to activate the tag. Click on File | Options. In the Word Options window that pops open select Add-Ins. Select Measurement Converter action from the Inactive add-ins and click on OK button. The tag will be added to the Active application add-ins.

Add-ins.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

In Word 2007 go Office button | Options | Add-ins | Manage Smart Tags.

In Word 2002 (XP) and Word 2003 the Smart Tags are configured from Tools | AutoCorrect Options | Smart Tags.


Measurement Converter Results

Result from the measurement converter is usually rounded off to two decimal places. Measurement converter is designed to work in this manner. Although the precision is set to two decimal place for most conversions it might vary for some however depending on the length of the number.

Another interesting feature of measurement converter is its ability of interpreting comma and dot based on region. If you look at the conversion result you will notice the use of comma to group the values and dot as the decimal point. Now if the comma and dot are placed correctly in the number then the measurement converter will convert it accordingly but if by mistake you use comma instead of dot i.e. for example if you write 88,1 instead of 88.1 then measurement converter will check the user’s location and language options and converts based on the format defined in that region. If you observe the below screenshot the conversion result varies based on the placement of comma and dot.

Comma.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com
Dot.jpg image from Measurement Converter Smart Tag / Action at Office-Watch.com

Measurement Converter supports the following conversions:























































































Length

Area

Volume

miles to kilometers

square feet to square miles

U.K. pints to liters

kilometers to miles

square miles to square feet

U.S. pints to liters

inches to centimeters

square yards to square miles

liters to U.K. pints

centimeters to inches

square miles to square yards

liters to U.S. pints

millimeters to inches

acres to hectares

liters to gallons

feet to centimeters

hectares to acres

gallons to liters

centimeters to feet

acres to square miles

ounces to deciliters

meters to feet

square miles to acres

deciliters to ounces

feet to meters

quarts to liters

yards to meters

liters to quarts

meters to yards

cubic feet to cubic miles

cubic miles to cubic feet

Temperature

Weight

Speed

Celsius to Fahrenheit

pounds to kilograms

mph to km/h

Fahrenheit to Celsius

kilograms to pounds

km/h to mph

grams to ounces

ounces to grams

stones to kilograms

kilograms to stones


Shortcomings

Like many Smart Tags / Actions, the Measurement Converter was developed by Microsoft years ago and seems to have been ignored since.

That’s a shame because the converter could be much more useful with some simple code updates.

We suspect that most people don’t want to replace one measurement with another, instead they want to supplement the measurement with an equivalent. For example change ‘5 miles’ to ‘5 miles (8km)’ or ‘8 km (5 miles)’.


Editing the Conversions

It is possible to edit, delete and add new measurement units to existing unit list. Measurement converter refers the Unicode text file metconv.txt for conversion purpose. You can open this file from the location C:Program FilesCommon Filesmicrosoft sharedSmart Tag and edit the contents.

Most people won’t need to edit metconv.txt, after all the conversion ratios won’t change.

You might want to tweak the names used to detect measurements, though the list is already quite comprehensive.

One addition we noticed was kilometers per hour, kmh or km/h. Strictly this should be km/h as the configuration file has. However it is more commonly written as ‘kmh’ and thus a phrase like ’12 kmh’ is not recognized by the add-in.

The line:

All, km/h, kilometers per hour, yes, no, mph, miles per hour, yes, 2, 0.6213712

might be usefully supplemented with an extra line

All, kmh, kilometers per hour, yes, no, mph, miles per hour, yes, 2, 0.6213712

 

You might want to add measurements. An astronomer might want to convert light-years into parsecs. An historian might want to convert cubit, stadion, ell or giru into more familiar measures.

If you do edit metconv.txt make you keep a copy of the original file just in case things go wrong.

Here each conversion rule is defined by 10 fields separated by commas. For example here’s the first line of metconv.txt

All, km, kilometers, yes, no, mi, miles, no, 2, 0.621371192237334

 

Refer the below table, from the help file supplied by Microsoft, for the field descriptions and the corresponding values to be given.





































































Field Description

Field Value

Example

Note

1

Locale for which the unit is recognized



  1. LCID
  2. “All” if recognized in all languages

All

The LCID is an identification number used by Windows to uniquely identify locales and languages.

2

Source unit name

Text

km

3

Source description

Text

kilometer

You can use the “&” character to define access keys in the description text. For example, “kilo&meter” will set “m” as the access key for this conversion rule.

4

Space between source unit and number

“Yes” or “No”

Yes

5

Is the source unit name case sensitive?

“Yes” or “No”

No

6

Destination unit name

Text

mi

7

Destination description

Text

mile

You can use the “&” character to define access keys in the description text. For example, “mi&le” will set “l” as the access key for this conversion rule.

8

Space between destination unit and number

“Yes” or “No”

Yes

9

Rounding precision (number of decimal places in the target)

Integer value ranging from 0 to 9

3

10

Conversion ratio or formula reference



  1. Float value ranging from 0.00000000000001 to 1000000. The value must not include a comma.
  2. “CTOF” (Celsius to Fahrenheit)
  3. “FTOC” (Fahrenheit to Celsius)
  4. “KTOSP” (kilograms to stones and pounds). If the formula reference is KTOSP, then the Destination Unit Name contains two strings delimited by “|”: “stones|pounds.”

0.6213712