Execl problem with numbers

G

Guest

I Have A CSV text File with a column of 16 numbers (Digits), but when I load
the File in Excel the last digit is always 0 on the end?
Excel 2000 Ver.
Please Help
Thanks
 
M

Mangesh Yadav

because excel supports only 15 digits of accuracy. If you want to perform
some calculation, then excel won't help, but if you don't want to perform
calculation on this number, simply enter it as text.

Mangesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number in text format in CSV file 3
Excel Changes My Last Digit to Zero 1
Setting defaults opening .csv files 2
how can I save an excel file with long number columns in cvs form. 3
Maximum amount of numbers in one Cell 2
duplicate numbers in a column 2
Loop 1
large numbers as text replaced with scientific notation 2

Top