CSV formatted numbers display incorrectly

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

I've pasted a range of large numbers over into Excel and
they display as follows. I guess I have exceeded the
limit to the number of character. How can i get these
numbers to display correctly. I've tried applying general
format and text format and wideneing the cell but nothing
seems to work

1.23457E+18
3.45463E+17
12t364278347845777
3.12762E+17

Thanks in advance

Sue
 
Hi
Excel can only display 15 significant digits. That's the maximum. So
your values could not be displayed with 15 significant digits -> Excel
shows them in scientific format
 
You must log in or register to reply here.

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

how do i increase the number of digits displayed 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Displaying a 12-digit Number 4
formatting negative numbers 1
Excel Number Conversions 2
Conditional formatting in Excel 2010 2
Custom Number Format for text 8
Using TEXT and &TEXT - display numbers with commas, underline text 2

Back
Top