digits after "."

Hi,

I wonder how to have only two (or less/more) digits after a "." (eg. 0.38)

I was thinking I could use "Left" expression, but it couldn't work at all times, eg. for 6digits number as well as a 4digits number...

Is it possible to define the number of digits after a "."?

Thanks for helping

Try: round(N * 100) / 100

for 2 decimal places, or 1000 for 3 decimal places, etc

It works well ! Thank you guy

Hey, finally, it doesn't work as well as I wish.

eg. when the number is "12.88", it works, but if it's "12.80", the result with the "round" function is "12.8"....

An idea ?

I'm sorry to be insistent, but I didn't figure out this problem.

Somebody would have any idea

Try this for setting text to a number to two decimal places:

int(num) & "." & int(num*100)%100