numbers convert to formula in csv

[SteveJ]

I can't get a column of 16 digit numbers to transfer when converting the file
from an xls to a csv file. The cells in the csv appear to be a scientific
formula (5.19E+15, 4.27E+15, etc.). When actually clicking in the cell, the
number displays correctly except for the last digit which displays as a 0. I
think this might have something to do with the +15 that's in the formula
since the number that should appear is 16 digits long.

I've tried formatting the column in the xls file as text, general and number
(without decimal) and end up with a variety of results when saving and then
opening the csv.

 

[SteveJ]

Problem solved. I had previously formatted the cells as text before saving
to csv and still had the problem, but I've just redone it and everything
worked as expected. I must have errored the first time I did it. Thank you
for your help.