Difficult to determine without seeing the code; can you post it please.

"Debbie" wrote:

I've created a button linked to several calculations. It begins by
calculating a percentage. Then I figure the dollars with that figure. Then I
figure the difference between the original dollar amt and the new dollar amt.
Then I copy this into the cells I want it to stay. I have 4 buttons I'm using
to cover 4 possible scenarios. They're all set at "Percent - Dollar - Dollar"
(and they're all set up to run via macro tied to the buttons. Now, on some,
when I click the button it's changing my first dollar to a percent. Why would
it do that and how can I prevent it?