Excel: DBF Files Do Not Support Number Labels

Last reviewed: February 18, 1998
Article ID: Q77429

4.00 5.00 7.00 | 1.00 2.20 3.00 4.00 5.00 WINDOWS | MACINTOSH kbother

Summary:

If a Microsoft Excel worksheet contains a database where the field labels are numbers, and you save the document in DBF2, DBF3, or DBF4 file format, when you reopen the document, the letter N appears in front of the numeric labels, and the characters following the first character are deleted. For example, if a field has a label of "123," after you save the file in a DBF format, the field heading reads "N1".

This occurs because the DBF file formats only support text as labels. for each of the fields. DBF file formats do not support numbers as labels.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 2.20 3.00 4.00 4.00a 5.00 5.00c 7.00 7.00a
Keywords : kbother
Version : 4.00 5.00 7.00 | 1.00 2.20 3.00
Platform : MACINTOSH WINDOWS

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: February 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.