2 Simple Ways to Convert International Number Formats in Excel

In this video, we show 2 simple ways to convert international number formats. This is a common Excel number problem when exporting data from systems or receiving from international offices. Fortunately, there are numerous Excel tricks to fix this Excel number problem. In this example, we have some values from Poland which use the decimal comma, instead of the decimal point recognised by my UK regional settings. We need to convert the decimal comma to point in Excel. The same technique can easily be done in reverse. This Excel number stored as text renders it useless. I cannot sum or chart these values until Excel recognises them as a number. The video shows 2 quick and simple techniques - no VBA, no complex formulas. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J