Is there a way to convert cells with numbers to a CSV file and keep the
formatting??

I have a file with a list of 50+ items that are over 12 digits each . .
..when I save it in as a CSV file it defaults to the Scientific Exponential
Notation (Ex: 9.78E+12) and loses any Excel formatting. Is there any way to
keep the number formating and save it as CSV? I tried saving it as text and
then as CSV but that didn't work.

Any ideas?

Thanks so much for your help!