truncate number of decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using sqrt method and it gives me the result that is upto 16 decimal
places but i want the result to be round to only 2 decimal places.

Ceiling method only gives the upper bound and floor method truncates all the
decimals.

Does anybody know a method to do this.
TIA
nafri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
truncating a decimal to 2 decimal places?? 5
Truncate a number using Numeric Format Switch 1
How do I truncate decimal places on a merged field? 1
Method to round numbers 3
Why is Excel rounding when I truncate? 1
truncating decimal on numbers 3
Question about rounding the decimal 14

Back
Top