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