i've had this happen to me numerous times. if your spreadsheet has a ton of numbers that are like this (mine did) you can do one of two things, either select the whole column and go edit, find, search by 00, replace and leave the replace field blank, it will automatically take out the extra two zero's and still keep it as a number and a percentage. you can also type in a seperat cell 100, copy that, select the column again, right click, paste special, in the middle section of that window say divide. that will also take care of it