Hi all,
I'm trying to convert the output of formulas in a range of cells (B2:B160) into a number. I'm familiar with a couple of ways to do this, but I'm trying to avoid the Paste -> Paste Special way.
I know that you can hit F2, then F9 in each cell to instantly convert, but does anyone know how to apply that method to a range of cells? Hitting two buttons 159 times in each column is something I'd like to avoid.
Thanks in advance!
David
Bookmarks