Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.