Hi.
When in numbers I export as CSV it make a file with ";" instead of ",". Problem is I can't import it in the system I'm using so two questions:
1. Is there a way to make Numbers separate as ","?
2. If I have a cell with a text block, including commas in the text, how this CSV file will manage that?
Many thanks,
Luiz
MacBook, OS X El Capitan (10.11.2), I miss my G5 Pro
The easiest way I think is to switch System Preferences > Language & Region to a Region that uses , instead of ; , for example 'United States.' After doing that you need to close all Numbers documents, quit, and relaunch. Then export. Check that the export has the , delimiters that you want, and then switch back to your Region and relaunch Numbers again to resume your normal work.
Numbers knows to wrap the text in " " when there is a , in the text.
SG
Thanks. It worked. 🙂 Would be better if Numbers has an option when exporting, but it's okay. 🙂
Glad the workaround worked. You can give feedback to Apple via Numbers > Provide Numbers Feedback in your menu. Thanks for the green tick!
SG
CSV Convertion
