Convert numbers / Show correct numbers (also for Excel output)

julianhoetzel

Hi guys,

I have a question regarding the correct display of numbers in the output

In one columns it says 1,066,269 (calculated as Fixed Decimal 19.2), but like to have it shown with dots, = 1,066,269.32 

I don't want to have it shown in a String since I need to use it for formulas. The other column (103.67) shows the correct format. 

Besides this, I'd like to have it shown in the Excel output in a German number format, i.e. 

1.066.269,32 & 103,67 (please not as a string) but as a Standard number in Excel. 

Thanks for helping.

Cheers

Julian

grossal

Hast du die Datentypen mal geprüft? Kann es sein, dass es sich um Integer statt Doubles handelt?

Bei mir werden auch bei großen Zahlen die Nachkommastellen korrekt angezeigt.

Viele Grüße

Alex