View Single Post
 
Old 04-23-2021, 10:22 PM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Oct 2016
Posts: 50
SoMany is on a distinguished road
Default Always convert text to number?

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.
Reply With Quote