Microsoft KB Archive/77429

= Excel: DBF Files Do Not Support Number Labels =

PSS ID Number: 77429

Article Last Modified on 7/30/2001



This article was previously published under Q77429



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 &quot;123,&quot; after you save the file in a DBF format, the field heading reads &quot;N1&quot;.

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.

Additional query words: 1.00 2.20 3.00 4.00 4.00a 5.00 5.00c 7.00 7.00a

Keywords: KB77429

Technology:

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.