I use excel 2000 with xp.
I have been trying to change the function from 2 dec to 0 dec but it will not work.
I go to format then cells and it shows 0 dec but when i put in a5 it shows .05 so when i put in a string for summation
i have to add 2 zeros to it so it wil show.
I have tried to change it then go back to 0 dec then save but it still does not work.
any solutions would be of help.