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

If you open a .csv file in Notepad you will see that it has no format.

As it's name implies, it is Values, Seperated by Commas.


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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487895

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