ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   save form (https://www.excelbanter.com/excel-discussion-misc-queries/167244-save-form.html)

naso

save form
 
Hello, i have a question about the CSV(Ms-Dos) save type.
When i save an xls file as the CSV form, when i open it again, it doesn't
have the CSV format, but it still has the regular one. Column lines, are not
being converted to " ," .Do i need to make any other adjustments before
saving it?

Dave Peterson

save form
 
If you're reopening the .csv file in Excel, then that could be a problem.

Try opening the .csv file in NotePad (or any other text editor).

Reopening the file in excel won't be a good way to check what the .csv file
looks like.

naso wrote:

Hello, i have a question about the CSV(Ms-Dos) save type.
When i save an xls file as the CSV form, when i open it again, it doesn't
have the CSV format, but it still has the regular one. Column lines, are not
being converted to " ," .Do i need to make any other adjustments before
saving it?


--

Dave Peterson

Jim Rech[_2_]

save form
 
If I follow you correctly...When you open the CVS file in Excel again it
automatically parses it. So to see that you are really saving try opening
the CVS file on a text editor like NotePad.

--
Jim
"naso" wrote in message
...
Hello, i have a question about the CSV(Ms-Dos) save type.
When i save an xls file as the CSV form, when i open it again, it doesn't
have the CSV format, but it still has the regular one. Column lines, are
not
being converted to " ," .Do i need to make any other adjustments before
saving it?





All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com