At the moment I have a number of cells where a previous user has multiplied by 100 already, and leaving the cell in number format.
I want to put the cell in the % format.
But of course doing this multiplies the cells value by 100.
So how can I remove the *100 part of the existing formulas in the cells, and replace it with a blank.
Whenever I used Find Replace, replacing with nothing, it deletes the whole cell! thanks
Bookmarks