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?
Find and replace?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
I don't think there is a solution to this problem besides changing your regional settings.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks