![]() ![]() ![]() I just want it to output all the same strings it had going in and I know Im not the only one. It also adds or removes quotes and commas. When done it would be nice if left everything alone but as you said it turns ,00.00 into ,0 and changes date and time formats or anything it thinks it a data or time. If you open Excel first you will get the Text Import Wizard and yes, you can use the Data From Text option too but that still leaves you with bad data. You get a few rows where there are carriage returns in the original CSV but that is it, everything else is in one cell in each row. If you just open the CSV it will open in Excel but it ignores the commas in the Comma Separated Variable file. Im no Excel expert and Im sure different visions have handled it defiantly over the years but Im now on Excel 2016 and this is the way its worked for (Me) the last 25+ years.
0 Comments
Leave a Reply. |