|
|
|
|
#1
07-01-2019, 08:55 AM
|
|||
|
|||
Simply rename Yourfile.csv as Yourfile.txt. Then open excel (no file opened), start open file dialog, set file type as *.txt, and open the file. You are given options like delimiter, field types, etc. Set for every column right field type, and open file - data will not be mangled then.
Maybe same options are given when you open csv file from Excel instead double-clicking it too, but I don't remember can you or not, and I don't have Excel available currently. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formatting a word file
|
cenicero | Word | 2 | 10-20-2016 05:53 PM |
| Saving as image file removes formatting | md61813 | PowerPoint | 0 | 03-01-2016 03:23 PM |
|
Appendix file looses some formatting when inserted
|
cglenn | Word | 2 | 03-04-2014 08:13 AM |
| Inserting 'Text from File' without loosing formatting | OverAchiever13 | Word | 2 | 05-28-2010 12:24 PM |
| Formatting changes automatically after closing file. | Rashmirathi | Word | 1 | 09-08-2009 01:55 PM |
Windows 8 
Office 2016
Hybrid Mode