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:

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

2. Choose the Goto button to display the Convert topic. Nautical mile is listed under Distance.

REFERENCES

"User s Guide 2," version 4.0, Chapter 4

KBCategory: kbusage KBSubcategory: Additional reference words: 4.00 4.00a err helpfile conversion engineering THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.