Forum Discussion
Data in the column automatically converted into general when i save it in CSV
Hai experts, in the first column when in enter data in excel 01.2020 in order upload to SAP whereas SAP accepts only CSV once i save the file in CSV format it data converted into general and it show...
It gives desired result when I open in notepad but in case I open CSV file it auto format to general and date and leading zero missing and result would be 1.202 (desired result is 01.2020)
Well, that's how Excel behaves. Even with the +/- recent addition of the following Options (Excel 365 only, top of my head):
this won't give you what you expect:
The only option I see is to import the CSV via Power Query and set your 1st column as Text (result attached)
HaiLorenzo
Thanks a lot, your solution almost solved the problem.
Not sure what you talk about (Excel options of Power Query) but you're welcome & Thanks for providing feedback
