I already studied this thread
and the solution from @prasath17 is working as long as you use the ‘english’ format of numbers, where the dot is the separator for the decimals and the comma for the thousands.
But when you use this macro for the ‘german’ format, where it is just the other way round you get a faulted format.
In the macro I used the follwing format:
As you can see here:
Sub macro() Range("K:AC").Select 'specify the range which suits your purpose With Selection Selection.NumberFormat = "#.##0,00" .Value = .Value End With End Sub
Many thanks in adavance for any assitance and help.