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;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
Негізгі бет Тәжірибелік нұсқаулар және стиль 2 Simple Ways to Convert International Number Formats in Excel
Пікірлер: 11