I am using excel as source for numbers. I am reading the number with ‘get cell value’ activity and then using ‘Number Format’ activity to convert the string to number. The source number in excel is 43525,89 (Nordic numbering format) and now when I utilize different preset format patterns it comes out as:
43525 (preset 0.00 + Finnish Locale)
43525 (preset #.00 + Finnish Locale)
43525.88999999999 (preset #.00 + English Locale) - this is also the same format how the system reads this from excel into temporary variable.
I wonder if there is some kind of bug here in the system.