Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Excel Worksheet keeps calculating to about 8 decimal places

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
Simonrepro
Asked:
Simonrepro
1 Solution
 
Martin LissRetired ProgrammerCommented:
Can you attach the spreadsheet?
0
 
Saqib Husain, SyedEngineerCommented:
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
 
SimonreproAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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

MyResult = Format(MyResult, "0.00")
0
 
stilldmoneyCommented:
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
 
SimonreproAuthor Commented:
That worked thanks!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now