numerical error
Srinivas:
The data is written to the CSV file as formatted in Excel - a text string of
14 digits. It is being reformatted by Excel to General format when you read
the file. Your choices a
1) reformat as Number, 0 decimal places each time you open the CSV file
or
2) On the Data menu, perform data import, specifying text as the datatype.
Bar codes as text should be OK, because you shouldn't be doing arithmetic on
them.
--
TedMi
"Srinivas" wrote:
Hi
When iam typing number (14 digits) in excel which is .csv format it is
giving error 8.9029E+12 like this i tried to format in general, number, text
but error remains same once i saved and reopen the file can any one help me
in this
Thanks
--
srinivas
|