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

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

Thanks for the answer but i dont want any decimal places
--
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

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

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


"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

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


"ShaneDevenshire" wrote:

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


"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

What happens if you make the column wider?

--
Rick (MVP - Excel)


"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

Sir,

Even when i m making column wide and save and reopen it is going back to same
--
srinivas


"Rick Rothstein" wrote:

What happens if you make the column wider?

--
Rick (MVP - Excel)


"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

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

"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

But sir,

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


--
srinivas


"David Biddulph" wrote:

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

"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

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 |




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

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" wrote in message
...
But sir,

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


--
srinivas


"David Biddulph" wrote:

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

"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

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

Not working

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


"David Biddulph" wrote:

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" wrote in message
...
But sir,

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


--
srinivas


"David Biddulph" wrote:

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

"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

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

Thanks for the reply, but our software takes only numerical when im trying to
upload its giving numerical error
--
srinivas


"muddan madhu" wrote:

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 |




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

"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" wrote in message
...
Not working

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


"David Biddulph" wrote:

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" wrote in message
...
But sir,

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


--
srinivas


"David Biddulph" wrote:

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

"Srinivas" wrote in message
...
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


"ShaneDevenshire" wrote:

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


"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

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

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

try this

Sub SaveFile()
Dim sf As String
ActiveCell.Select
Selection.NumberFormat = "0"
sf = ThisWorkbook.Path
ThisWorkbook.SaveAs Filename:=sf & "\" & "123" & ".csv"
End Sub



On Sep 29, 5:12*am, Srinivas
wrote:
Thanks for the reply, but our software takes only numerical when im trying to
upload its giving numerical error
--
srinivas



"muddan madhu" wrote:
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 |

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- Hide quoted text -

- Show quoted text -

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

"Srinivas" wrote:

Thanks for the reply, but our software takes only numerical when im trying to
upload its giving numerical error
--
srinivas


"muddan madhu" wrote:

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 |




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