Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should warn about commas when saving .csv files.
Using Excel 2003 or previous version.
When a worksheet with any number of cells containing numbers and/or text including the comma ',' character is saved as a *.csv (Comma Delimited file), there should be a warning or alert notifying the user. This alert should give the choice of continuing to save the file, or going back and removing the commas or replacing them with a different character. This alert should give a brief description of the consequences of keeping the commas (ie. they will be interpreted as an extra field when the file is reopened.) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should warn about commas when saving .csv files.
Excel will put double quotes around fields with embedded commas.
If you open a CSV file, excel will be smart enough to know that you're in one field. Are you experiencing something else? What version of excel are you using? hydroEng wrote: Using Excel 2003 or previous version. When a worksheet with any number of cells containing numbers and/or text including the comma ',' character is saved as a *.csv (Comma Delimited file), there should be a warning or alert notifying the user. This alert should give the choice of continuing to save the file, or going back and removing the commas or replacing them with a different character. This alert should give a brief description of the consequences of keeping the commas (ie. they will be interpreted as an extra field when the file is reopened.) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
Bizarre MS EXCEL problem - files will not open via document ICONs | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Issue opening csv files in Excel | Excel Discussion (Misc queries) | |||
.csv Files in Excel | Excel Discussion (Misc queries) |