I am trying to save an xls spreadsheet to a .csv file.

I have formatted one of my columns as text.

When I save the file as xls the data stays in tact.

When I save the file as csv that column changes values to exponential.

What am I doing wrong?

Thanks
--
PTL