In my column B, there is some Cell with Fix Value, some with formula and the formula aint the same. I want to do Round2 for all. My B1 is a formula (eg C1+D1), hence i select the whole column B. Put the Round2 formula in B1, then CTRL Enter. Now all column B has Round2, however, i discover ALL formula become (C2+D2, C3+D3 etc etc.) Even my Fix value has formula now. How can i just add Round2 formula to all cell using the Ctrl Enter method Without amending the original content/formula of the cell???
Bookmarks