A CSV file is NOT an Excel file and does not have any formatting. It is just
a text file which uses commas to de-limit the data CSV = Comma Separated
Values. It often only opens within Excel if the extension .csv has been
linked to Excel.

If you want to use existing formating you need to have a previously
formatted sheet and then copy and paste values.

If you do ANY work on a CSV file in Excel you must save it as an Excel
s/sheet or you will lose formatting and formulas.

Excel does warn you.

Roger

"Chris" wrote:

Why when I open up an existing CSv file does it lose all its formatting. Why,
when some cells are formatted as text do thay convert to general when the
file is opened