5.68434E-14

BoRacho

New Member
Joined
Dec 22, 2005
Messages
24
I'm working in a excel database and one of my columns isn't adding up...instead of get th 5.68434E-14. I've double-checked the format of the cells, format painted from columns that work properly and even re-created the list in another sheet and either inserted a column or pasted over the original data. None of it seems to work and its screwing up a pivot table. Any suggestions?....Thanks in advance for your help.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
I assume you're expecting a sum of zero? You effectively have that within the limits of Excel (it's a very small number) and the limitation imposed by binary representations of decimal numbers.

You may need to consider either explicitly rounding your figures or (potentially dangerous option) using Precision As Displayed option in Tools>Options.

Richard
 

BoRacho

New Member
Joined
Dec 22, 2005
Messages
24
Exactly, the figure has to get back to zero. I'll give your tip a shot....thanks!
 

BoRacho

New Member
Joined
Dec 22, 2005
Messages
24
Just as I was taking your suggestion to the bossman, he came to my office to say he went to the pivot table and right-clicked the cell, format cells, and selected the number format and it worked. Its definitely Friday. Thanks for your help, and I'll keep that in mind if it ever comes up again.
 

Forum statistics

Threads
1,136,928
Messages
5,678,623
Members
419,776
Latest member
mikelowski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top