Hi I am trying to scroll down all 3 at once and only change the number going from 8 9 10 11 leaving the letters the same. I cant figure out a way to do this and been copying and pasting and taking forever.
=IF(Data!I8=0,TEXT(Data!I8,""),Data!I8)
=IF(Data!J8=0,TEXT(Data!J8,""),Data!J8)...