on a related problem, does anyone know how to copy a sentence which has a comma in it and paste it into a single cell (on excel), without all the words after the comma being automatically pasted in the next cell along?
This is something to do with your default settings on your ‘import data’ function. If you go to tools .. options (in excel) and then look through that, there should be something in there. Failing that go to on-line help.
Excel is reading comma as a break point by default. I had the same problem with weight being imported as a date.