
I was inputting a value of 100% into a couple of different columns (database) but then I found out that the percent sign % shouldn't be there. So I tried to delete it. But when I delete just the % sign or delete the entire value of 100% and then enter the value of 100, for some reason I get 10000.00%.
I've tried different cells and it's always the same! If the value was 50% and I try to change to 50 it makes it 5000.00%
So not only it won't let me delete the % sign and puts it right back but it also adds a couple of 00 to every value I enter
I would appreciate some help!