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