Imagine you are monitoring a stock price in a cell that autoupdates using the external data option, so you get 10,000.10, then after 60 seconds it updates and you get 10,020.10 or whatever.
My question is, how do I automatically get the stock price to update but switching the comma with a point and the point with a comma? because in my country we don’t use 10,020.10 but 10.020,10 but the website im using gives you 10,020.10 so I need to replace them.
I’ve tried te substitute function but it’s not working. Any helps?