Forum Discussion
Excel treats numbers as text
In the first place, the values use comma as decimal separator.
If you use point as decimal separator, press Ctrl+H to activate the Replace dialog.
Enter a comma in the 'Find what' box and a point in the 'Replace with' box, then click 'Replace All'.
Of course, if you use comma as decimal separator, you should skip that.
In the second place, the values use a space as thousands separator.
Press Ctrl+H to activate the Replace dialog.
Enter a space in the 'Find what' box and clear the 'Replace with' box so that it is empty, then click 'Replace All'.
In the first place, the values use comma as decimal separator.
If you use point as decimal separator, press Ctrl+H to activate the Replace dialog.
Enter a comma in the 'Find what' box and a point in the 'Replace with' box, then click 'Replace All'.
Of course, if you use comma as decimal separator, you should skip that.
In the second place, the values use a space as thousands separator.
Press Ctrl+H to activate the Replace dialog.
Enter a space in the 'Find what' box and clear the 'Replace with' box so that it is empty, then click 'Replace All'.