Numbers 6.2 exports CSV using semicolons instead of commas

Question

Level 1

42 points

Numbers 6.2 exports CSV using semicolons instead of commas

Numbers 6.2 exports CSV using semicolons instead of commas and there is no option to choose which separator to use. Any ideas how to fix this?!

Posted on Nov 3, 2019 10:38 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

36,092 points

Nov 3, 2019 8:24 PM in response to teomor

That's probably because your computer or Numbers is set to a region that uses , as the decimal separator.

You can switch temporarily to a region that uses . as a decimal separator, then export, then switch back. Go to File > Advanced > Language and Region ... to switch.

SG

Reply

Answer 2

teomor Author

Level 1

42 points

Nov 3, 2019 10:37 PM in response to SGIII

Hehe. That did it. Thanks a lot! I have a new Mac and set it up differently I guess... I had probably customized the old one to use the . as a decimal separator and forgot to do that on the new one too.

PS: I actually thought about this as being the reason, but didn't seem right to me. It still doesn't :)

Reply