csv (comma delimited)

0

hello,

when I save my excel to csv (comma delimited)

then open it on notepad.  the separator  is semi colon (;) instead of comma (,)

please advice how to save it in comma

thanks

lucy

Answer
Discuss

Answers

0

In Windows, go to the Control Panel > Region and Language > Formats tab > click Additional Settings > Number tab > change the value for the List separator to a comma > click OK.

Discuss

Discussion

hello don
I cannot find the format in the region and language . when i click the language or region there's no format or additonal setting
lucy8888
lucy8888 Aug 5, '16 at 8:36 pm
It's a Format tab at the top of the window. It should be open  by default.
don (rep: 1482) Aug 8, '16 at 4:29 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login