Thread: numerical error
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
TedMi TedMi is offline
external usenet poster
 
Posts: 52
Default 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