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" 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
|