Format a number to two decimal places only (discarding the rest)?

[peskywinnets]

What function/formula should I use to limit a number to TWO decimal places (I don't want to round), example


3.713 ...I only want 3.71

25.8576 ...I only want 25.85

thanks in advance

 

[theDBguy]

Hi. Try

Int(25.8576*100)/100

 

[Gasman]

Find the decimal point with Instr and add 2 to that value and use the Left function with that value.?

tt=25.8781
? instr(tt,".")
 3 
? left(tt,instr(tt,".")+2)
25.87

You might need to convert back to numeric?

 

[Gasman]

Hi. Try

Int(25.8576*100)/100

There you go, a much more concise and better solution and stays numeric.

 

[peskywinnets]

Many thanks!

 

[theDBguy]

Many thanks!

Hi. You're welcome. Gasman and I were happy to assist. Good luck with your project.