Convert Comma to Decimal Point in Excel

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=ADcdv5KyPII

How to convert a comma to a decimal point in Excel using a formula. • Some countries from continental Europe such as Germany, Austria and Switzerland use a decimal comma instead of the decimal point used in the UK, USA and many others. • This means that when importing data from one of their systems, Excel may not recognise the number due to its location settings. • This video tutorial looks at how to convert the comma to a decimal point using a formula. The formula uses the SUBSTITUTE and VALUE functions. • The formula used in the video is shown below; • =VALUE(SUBSTITUTE(SUBSTITUTE(A2, . , ), , , . )) • 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/37XSKfZ • Advanced Excel Tricks ► https://bit.ly/3CGCm3M • Excel Formulas Made Easy ► http://bit.ly/2ujtOAN • Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm • Connect with us! • LinkedIn ► / 18737946 • Instagram ► / computergaga1 • Twitter ► / computergaga1

#############################

New on site