what is csv file? i can open with excel but cant do sorting. while some
chnages can be made i dont seem to save the file.

CSV stands for comma separated values. The commas are delimiters that tell
excel where to break each rows data into separate columns. When you open the
csv file you should get the import wizard which asks if it's fixed width or
delimited, choose delimited, then click the next button and click the comma
checkbox, then the finish button. No reason you shouldn't be able to sort the
data.

"chiuinggum" wrote:

what is csv file? i can open with excel but cant do sorting. while some
chnages can be made i dont seem to save the file.

i just try out and bold the header. i save the file and re-open it. nothing
changed on the header....still plain text

"headly" wrote:

CSV stands for comma separated values. The commas are delimiters that tell
excel where to break each rows data into separate columns. When you open the
csv file you should get the import wizard which asks if it's fixed width or
delimited, choose delimited, then click the next button and click the comma
checkbox, then the finish button. No reason you shouldn't be able to sort the
data.

"chiuinggum" wrote:

what is csv file? i can open with excel but cant do sorting. while some
chnages can be made i dont seem to save the file.

CSV files are plain text--they don't save formatting or formulas or page breaks
or any of that stuff.


chiuinggum wrote:

i just try out and bold the header. i save the file and re-open it. nothing
changed on the header....still plain text

"headly" wrote:

CSV stands for comma separated values. The commas are delimiters that tell
excel where to break each rows data into separate columns. When you open the
csv file you should get the import wizard which asks if it's fixed width or
delimited, choose delimited, then click the next button and click the comma
checkbox, then the finish button. No reason you shouldn't be able to sort the
data.

"chiuinggum" wrote:

what is csv file? i can open with excel but cant do sorting. while some
chnages can be made i dont seem to save the file.

--

Dave Peterson

You can't just save a CSV file in Excel straightaway if you have done
any formatting changes such as bolding the headers..

Because any formatting done it will be lost when you save it.

After you have imported the CSV file into Excel and done some changes,
save it as an Excel file (eg.. Save As).

If you really need to export it out, then you can save as CSV. But, the
formatting will be gone.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=550716