1 Publication 1756-RM084F-EN-P - July 2002
Appendix
B
Considerations for Using Microsoft Excel to
Edit a .CSV File
Introduction
This appendix describes how using Microsoft Excel can affect a
.CSV file.
Recommendations
If you use Microsoft Excel to edit your .CSV tag file:
•
Use single quotes instead of double quotes within descriptions
and comments.
•
Do not create descriptions or comments that consist only of
numbers, have leading zeros, or have a leading symbol that
Microsoft Excel treats specially. For example, do not create
descriptions like:
002
+2
=2
-2
.0
• Do not create descriptions or comments that start with a +, -, or
= symbol. Even if you add text after the symbol, Excel displays
#NAME? in the cell.
IMPORTANT
To edit the .CSV file, it is recommended that you use a
database program tool, such as Microsoft Access, or a
raw text editor. Many other desktop tools, such as
Microsoft Word or Excel, might change the structure
of the .CSV file and cause an import of the file to fail.
Spare Allen-Bradley Parts
To Next Page
Loading...
