CSV formatted numbers display incorrectly

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
 
F

Frank Kabel

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
 
Top