CSV files can be opened directly with just a double-click in Explorer because. That opens the text file with the Text Import Wizard which has some conversion options including forcing a field to text. The old way to import text is simply to File | Open and select the file. Text can be mistaken for dates or even large numbers. Numeric Identifying codes or SKU’s are converted to numbers. Modern Excel for Windows has a much better way to import text files and other data which will avoid or fix problems that the older Open file or Text Import Wizard options cause.Įxcel tries to help when opening text files like CSV or TSV by converting text into cell types like dates, numbers etc.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |