Thread: numerical error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default numerical error

Excel is converting the number to Scientific notation. You want to go to
formating and change the number of decimal places to a larger number to
handle you large numbers.

"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