Convert Comma to Decimal Point in Excel
Автор: Computergaga
Загружено: 2015-10-01
Просмотров: 192231
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: