Need to Change the format of a column in Excel Sheet (german format)

[mbe (Markus Berg)]

Hi everybody,

I already studied this thread
https://forum.uipath.com/t/need-to-change-the-format-of-a-column-in-excel-sheet/301643

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.

Input:

Output:

In the macro I used the follwing format:
“#.##0,00”

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.

Yours

[ppr (Peter Preuss)]

we can use following activity:

[mbe (Markus Berg)]

Thanks for the advice @ppr , but with this activity I have the same problem.

I already mentioned it in this post here to BalaReva.
https://forum.uipath.com/t/uipath-go-balareva-easyexcel-activities/166961/152?u=mbe

[ppr (Peter Preuss)]

in that case a debug on the datatable content / Excel cell content can help to find out the root cause

[prasath17 (Guru)]

@mbe - Could you please let us know the desired output format?

[mbe (Markus Berg)]

@prasath17
The correct format would be

And this is the setting in Excel

as I already used in the macro.

[mbe (Markus Berg)]

Sorry @ppr , but even in the debugging mode of the studio you cannot see any irregularities.

[ppr (Peter Preuss)]

Es gibt immer einen Grund

[mbe (Markus Berg)]

Hi everybody,

I finally made it with this short macro, which I recorded in Excel and that it worked.

Sub Makro()
 Columns("G:Y").Select
 Selection.NumberFormat = "#,##0.00"
End Sub

It is interessting and I don´t have any explanation for this, but with this format in the macro the number format in Excel is correct, even it is the otherway round.
So, maybe this could help others.
Yours