Reducing Number Precision

  • Thread starter Thread starter lcs34
  • Start date Start date
L

lcs34

I have a large worksheet made up of numbers of high
precision - about 8 decimal places. Is there a way I can
reduce this in excel to say 2 decimal places as I do not
require a precision higher than that?
 
If they are formulas you can use

=TRUNC(A1,2)

if they are constants you can use a number format with 2 decimals,
then apply temporarily tools>options>calculations and precision as displayed
Note that the latter will round the second digit. Then you can remove it
 

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
formatting negative numbers 1
Precision As Displayed Has Failed Me--Help 12
Can I change the precision of Excel calculations 2
extract decimal and convert to integer 9
Formatting Question 2
Problems With Precision while Linking Tables 4
Reducing decimal places 4

Back
Top