Quote:
Originally Posted by macropod
That's all very well, but the OP hasn't said the aim is to produce a text file.
|
After his regional settings are set back again, when he opens the csv-file from Excel and saves it as Excel file, all entries will be in column A - separated with semicolons.
Quote:
|
Besides he's using a Mac, which probably means he's not using Windows and, even if he were, mucking around with the Window's regional settings is not to be lightly advised.
|
This leaves him with the variant B then. Btw. even when his entries originally contain commas, then there is a workaround. Before saving the table as csv-file, he has to replace all commas with some other (unused) chartacter, p.e. "_". And after opening the csv-file and saving it to Excel format, he has to replace this character with comma everywhere again.