Columns of data are separated by commas, and each row of data ends in a carriage return.
If cells display formulas instead of formula values, the formulas are converted as text.
Formatting needs to be done in In Design because things like background colors seem to break (never mind Excel not knowing spot colors) , and is more complex than can be done with table styles.
Otherwise, data may be lost or not properly separated in the converted file.
The following file formats have feature and formatting differences as described.
This file format (.prn) saves only the text and values as they are displayed in cells of the active worksheet.
All formatting, graphics, objects, and other worksheet contents are lost.
The euro symbol will be converted to a question mark.