Excel: DBF Files Do Not Support Number Labels

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.

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

Keywords          : 
Version           : 4.00 5.00 7.00 | 1.00 2.20 3.00
Platform          : MACINTOSH WINDOWS 
Issue type        : 

Last Reviewed: March 22, 1999