Solved

# Excel Worksheet keeps calculating to about 8 decimal places

Posted on 2012-09-04
274 Views
Hi,
I have a spread sheet which keeps calculating to loads of decimal places even though I have told it to only do this to two places.  I can see two places but when it adds it together it rounds up or down as if it is calculating to more places.

Any ideas?

Simon
0
Question by:Simonrepro

LVL 44

Expert Comment

Can you attach the spreadsheet?
0

LVL 43

Expert Comment

The internal calculations will always be to 15 digits. What you probably have told it is to DISPLAY the numbers to 2 decimal places.

To do rounded calculations you will have to use the round function with your formulas

=round(<yourformula>,2)
0

Author Comment

I don't want it to round, I want it to add together a load of numbers which are to two decimal places and give me the result as a two decimal places result.  That should not need rounding.
0

LVL 44

Expert Comment

Again, if you could attach your worksheet it would help us help you, but try something like

MyResult = Format(MyResult, "0.00")
0

LVL 1

Accepted Solution

Have you tried copying all your spreadsheet info to a new Excel spreadsheet? I've seen instances where formulas don't work the way they're supposed to and I copy & paste everything to a new workbook and it does the trick... just a thought.
0

Author Closing Comment

That worked thanks!
0

## Write Comment

Please enter a first name

Please enter a last name

We will never share this with anyone.

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

#### 760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!