Hi. So I'm downloading data from an external application into Excel. The problem is a lot of the data is 'Number stored as text'.
Using VB, how can I 'Convert to number'. I have hundreds of instances of this problem so manual corrections are impractical.
Using VB, how can I 'Convert to number'. I have hundreds of instances of this problem so manual corrections are impractical.