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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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