Try formatting the column as Number with zero decimal places (not
Text).


--JP

On Nov 20, 5:01 pm, "JoeSpareBedroom" wrote:
OK, so the guy who's sending them is naming the file with a csv extension,
but not choosing the correct file type, which wouldn't work anyway since the
first sheet is already at its limit of records. Onward:

The data looks right in the sheet when I open it. If I open a brand new
Excel sheet, format the cells as text, and copy the data to the new sheet
using Paste Special/Values, why are those long strings turning into
exponential format?