Microsoft KB Archive/110003

= Microsoft Knowledge Base =

XL4: CONVERT Returns #N/A If "nmi" Used for Nautical Mile
Last reviewed: September 12, 1996

Article ID: Q110003

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
In Microsoft Excel version 4.0, when you are using the CONVERT function, if you use the abbreviation "nmi" for Nautical Miles, you will receive an #N/A error value. The correct abbreviation is "Nmi", where the N is capitalized.

Microsoft Excel Help for version 4.0 states that the abbreviation for nautical miles is "nmi." This information is incorrect. Page 64 of the "Function Reference" has the correct "Nmi" abbreviation.

MORE INFORMATION
The CONVERT function is used to convert numbers from one unit of measure to another (feet to meters, miles to kilometers, and so on).

If this function is not available, you must install the Analysis ToolPak add-in macro.

For more information about add-in macros, see "Managing Add-in Commands and Functions" in Chapter 4 of the "User's Guide 2," version 4.0.

To locate the error in Microsoft Excel Help:

  In Microsoft Excel for Windows, choose Search from the Help menu and type "Convert" (without the quotation marks). -or- In Microsoft Excel for the Macintosh, from the Balloon Help menu, choose Microsoft Excel Help, choose the Search button, type "Convert" (without the quotation marks), and choose the Show Topics button.  Choose the Goto button to display the Convert topic. Nautical mile is listed under Distance.