numerical error

  • Thread starter Thread starter Srinivas
  • Start date Start date
S

Srinivas

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
 
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.
 
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,
 
Hi,

1. Choose Format, Cells, Number tab, Number, 0 decimals
2. Widen the column as far as necessary to see the 14 digits.
 
Sir,

I tried all this it is not working if it is excel it will work but the file
is .csv format once iam formatting like this save and once i reopen the file
it is going again same format.

Regards,
 
But sir,

my software uploads only .csv files in that i have barcode of 14 digits so i
want the help.


--
srinivas


David Biddulph said:
CSV is text, it does *not* contain formatting. [Look at it with a text
edior like Notepad.]

If you want to alter the formatting of a number, you need an Excel file, not
a CSV.
Click to expand...
 
try this

format cells | number tab | category :number | decimal places :0 | ok
|
File | save as | csv extension | ok | then rename the saved file
as .txt |
then open new excel | file | open | choose file type : all files |
choose file | open | delimited | next |
check comma | next | choose text option as display 14 digit | finish |
 
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....
 
Not working

I want csv file to upload and the number is 14 digits
--
srinivas


David Biddulph said:
If you have a CSV file with the 14 digits, and you don't want Excel to
reformat for you, read it in as text. Use Excel's Data/ Import External
Data, and specify the column as text, rather than just opening the CSV file
with Excel.
--
David Biddulph

Srinivas said:
But sir,

my software uploads only .csv files in that i have barcode of 14 digits so
i
want the help.


--
srinivas


David Biddulph said:
CSV is text, it does *not* contain formatting. [Look at it with a text
edior like Notepad.]

If you want to alter the formatting of a number, you need an Excel file,
not
a CSV.
--
David Biddulph

Sir,

I tried all this it is not working if it is excel it will work but the
file
is .csv format once iam formatting like this save and once i reopen the
file
it is going again same format.

Regards,
--
srinivas


:

Hi,

1. Choose Format, Cells, Number tab, Number, 0 decimals
2. Widen the column as far as necessary to see the 14 digits.

--
Thanks,
Shane Devenshire


:

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


:

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.

:

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
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the reply, but our software takes only numerical when im trying to
upload its giving numerical error
 
"Not working" isn't a very specific problem description.
I assume that you haven't read my message to which you are replying?
--
David Biddulph

Srinivas said:
Not working

I want csv file to upload and the number is 14 digits
--
srinivas


David Biddulph said:
If you have a CSV file with the 14 digits, and you don't want Excel to
reformat for you, read it in as text. Use Excel's Data/ Import External
Data, and specify the column as text, rather than just opening the CSV
file
with Excel.
--
David Biddulph

Srinivas said:
But sir,

my software uploads only .csv files in that i have barcode of 14 digits
so
i
want the help.


--
srinivas


:

CSV is text, it does *not* contain formatting. [Look at it with a
text
edior like Notepad.]

If you want to alter the formatting of a number, you need an Excel
file,
not
a CSV.
--
David Biddulph

Sir,

I tried all this it is not working if it is excel it will work but
the
file
is .csv format once iam formatting like this save and once i reopen
the
file
it is going again same format.

Regards,
--
srinivas


:

Hi,

1. Choose Format, Cells, Number tab, Number, 0 decimals
2. Widen the column as far as necessary to see the 14 digits.

--
Thanks,
Shane Devenshire


:

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


:

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.

:

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
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...

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

--ron
 
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 are:
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.
 
try this

Sub SaveFile()
Dim sf As String
ActiveCell.Select
Selection.NumberFormat = "0"
sf = ThisWorkbook.Path
ThisWorkbook.SaveAs Filename:=sf & "\" & "123" & ".csv"
End Sub
 
Ok everyone here is how it works i have tested and proved this theory.

If you import your data and tell it is text it ignores that fact all
together, If you format your worksheet and then delimitate it throws out your
formatting every time. This is true in 2003 & 2007 here is how you get
around this.

Open excel copy and paste your data into a worksheet, delimitate that work
sheet to the format needed. At this point your data is bad. Now click a new
worksheet click the diamond of sheet 2 in the corner and format that sheet as
text. Then paste your data into the sheet.

It will keep the style of delimitation and keep your data true no more
scientific format no more having that number rounded and changed
 
Back
Top