numerical error
IF SAME FILE I OPEN TWICE ITS GOING BACK TO SAME
--
srinivas
"muddan madhu" wrote:
might help u
suppose u have data in A1 in b1 put this formula
=text(A1,"'00000000000000")
and then save it in csv ...
u can see the 14 digit number in csv file....
On Sep 29, 10:30 am, Srinivas
wrote:
Sir,
Actually I am uploading a barcode file which is in .csv format to our
software. Our barcodes are 14 digits when im uploading it is taking like
8.9029E+12 instead of 8902900259286 what ever doing format once i close and
opens it is again going to 8.9029E+12 format. Please help me
Thanks & regards,
--
srinivas
"Joel" wrote:
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
|