Computer Tutoring Logo

Change Comma to Dot in Excel


Why change comma to dot in Excel?

How do you change comma to dot in Excel? This can be a complicated problem and beforehand we used a formula. (Please see: Change comma to dot in Excel tutorial).This time though changing a comma to a dot is facilitated by the text to columns feature which makes this process a whole lot easier.

Sometimes when dealing with European currencies the comma and the decimal point is the wrong way round. Well, it's the wrong way round for the UK. But the correct way for many countries in Europe. This training video will show you how to sort this little problem out. By the end you'll see how to change a comma to a dot in Excel thereby solving this decimalisation nightmare.