3 ms·
I don't understand what's wrong with the existing solution of: Right Click > Format Cells > Text. Set the data type of the column and Excel will not fiddle wi
by Amezarak 3y ago
I don't understand what's wrong with the existing solution of:
Right Click > Format Cells > Text.
Set the data type of the column and Excel will not fiddle with it. Let it stay implicit and Excel will to guess. This change is saved in the file. The article only slightly touches on this: converting to CSV and losing all the Excel formatting and then opening it in Excel again.
- acdha 3y agoThe problem with that is that you have to remember to do it before Excel loses data.
- imtringued 3y agoExcel doesn't support CSV so expecting that to work is like expecting your car to fly. Just because they have something they call CSV import or export doesn't mean the feature actually works.