Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have to format an expression into an expression with 2,3 or 4 digits after the comma:
1335,1 - 1.335,10
1335,14 - 1.335,14
1335,145 - 1.335,145
1335,1456 - 1.335,1456
1335,14567- 1.335,1457
I tried
Num( 1335,1456, '#.##0,00##', ',' , '.' ),
but there is no difference to
Num( 1335,1456, '#.##0,0000', ',' , '.' ) .
Any suggestions?
Thank You
ez
You could set the formatting explicitely depending on the number of digits. The following looked a bit ugly but it worked:
num(1335.1, '#.##0,' & repeat('#', rangemax(2, rangemin(len(subfield(1335.1, '.', 2)), 4))))
- Marcus
You could set the formatting explicitely depending on the number of digits. The following looked a bit ugly but it worked:
num(1335.1, '#.##0,' & repeat('#', rangemax(2, rangemin(len(subfield(1335.1, '.', 2)), 4))))
- Marcus
Thank you Marcus,
it works.