A quicky for you,
I open a CSV file in excel 2007, it has many lines of the following data, all exactly the same format:
I want to make a simple change to one of the columns (which i know how to do) and then save again. As expected, Excel comes up with that message saying there are incompatable characters in the CSV that excel dont like or whatever, its a common message. So as usual I click No to preserve my existing format. However, when I open my csv in a text viewer I still find it has removed things like - and chops 0's of the end of cells.
Does not matter if you click yes or no to that message, excel still messes around with data I have not touched.
example of its damage:
How do I stop excel changing anything unless I change it myself? A walkthrough instruction would be useful of how I can open, edit a coloumn, save, then close, without anything else being touched.