I work with teams from multiple countries and sometimes I receive excel files that have another decimal separator than the one I use. Is there any formula to do that? I certainly could use a macro, but a formula would be much easier because I am not the only person in my company in need of this and a macro would be too complicated for the general Joe Public.
Please keep in mind that I may have multiple separators in the same number, for example, 3.000.000,00 has 2 points for the thousands and millions, and the comma for the decimals. That is why I am finding it difficult.