Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i would like to know if it is possible to put figures into integers and express then in MEUR.
For example if i have this number in a graph/text box....:
1526321.25585
I want to obtain this: 1 526 321
Thank you, Helene
Hi Helene,
Use the floor function
floor(1526321.25585)
would return 1526321
thanks,
Rajesh Vaswani
Hi, you can try the Num() Function.
Num(FieldNumber,'# ##0') As FieldNumber
Best Regards.
Tonial.
If it's already in a chart. Go to the number tab choose integer. Then the in the box where it says "thousand separator" replace the comma and just hit the space bar.