Question regarding Num function

[pauljohansson]

Hi,

I have a questions thats propably really simply - but i dont manage to get it right.

Im loading numbers ranging from 55326 to 16487100.

Now i simply want to interpret these to 553,26 and 164871,00 etc..

I guess I should use the Num function, but in the reference documentation examples i cant find any similar case.

Please advice,

br
Paul

[Gysbert_Wassenaar · Accepted solution]

Check the settings for the thousands separator and the decimal separator first.

SET ThousandSep='.';

SET DecimalSep=',';

Next, is 553,26 the result of 55326 / 100? If so, you need to calculate that first: num(55326/100). You can specify a number format: num(55326/100,'#,##') to format it to show two decimals.