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.