I recently changed the list separator in my regional settings in Windows to pipe character. I upload CSV files that have commas in the body of the upload and had to change to a different character to avoid any issues.

But, doing so also changed all commas in my excel files to the pipe character as well. Also, now when i enter my formulae, I have to make sure that I put in the pipe character, where usually a comma would be.

Anyone else came across this problem and how to fix it?