I have searched google groups and this forum but couldn't find anyone else with this error, so I apologize in advance if this has been discussed and solved in the past.

It is hard to describe the process giving the error but it is like this : I can go to a cell such as A1 and type a zero in and it displays as a zero. I can hit enter on the cell and it still works perfectly. When I go to A2 I put in the forumula ' =A1 ', hit enter, and it still works fine and displays a zero. Now is the weird part, I click on A2 and hit enter again and the field changes to 0.00%. This same error happens when I set A2 equal to a blank field (one I have not entered zero in). I have checked all the options and formatting properties, and I think it is in one of the macros (the macros are too long to be useful posting on here I think) so if anyone has had a similar problem or a suggestion on where to look to try to solve this I would appreciate it.

I should add the reason this is a problem is that my macro does a copy/paste of a dataset, and the fields which are blank are getting pasted as 0.00%