As far as I can tell, the only way to prevent this from happening on import is to rename the file so the extension isn't. When I do, it formats columns containing numbers, which makes them useless for my purposes. How can I set Excel to always import all columns of CSV files as Text? Though I try to avoid it, I occasionally have to open a CSV file in Excel. Though I try to avoid it, I occasionally have to open a CSV file in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |