Before I go down the VBA rabbit hole, is there any way to get an entire sheet to always convert text to number?


I have a macro that copies a sheet onto the file I use. The data is always listed as text. This makes using formulas to interpret that text impossible. Before I start playing with my code, I want to know if I can make a sheet automatically convert to number? For an example of the type of macro I'm using, it can be found here.


Edit; I'm aware of a list of ways to manually do it, but I don't want manual, I want automatic. The formula =Value(B1:B100) showed a value of 2 when it was a value of 156. Even if there's no way to get the sheet to always convert to number, I'd be happy with a formula that interprets the data just the same.