Thread: numerical error
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default numerical error

On Sun, 28 Sep 2008 21:38:23 -0700, 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


1. Format the cell(s) properly:
Format Cells/Number/Custom Type: 00000000000000
(that's 14 zeros)
2. Save the file in CSV format.

--ron