Hello
I have a problem. So let say i have this set of data set, and some of them are blank. I want to replace these blanks with a 0, so i tried using go to special and change it to blank, it did not work for me. However it only work if i clear the blank cell with a backspace, then i tried it again and it work. I was wondering if there away where i dont have to backspace every blank cell to use the go to special?
I have a problem. So let say i have this set of data set, and some of them are blank. I want to replace these blanks with a 0, so i tried using go to special and change it to blank, it did not work for me. However it only work if i clear the blank cell with a backspace, then i tried it again and it work. I was wondering if there away where i dont have to backspace every blank cell to use the go to special?