Posts by trustodium

    Re: Converting Numbers Stored As Text To Numbers Via Macro

    As this comes up very high in Google search result so I thought to reply to this very old post.
    The best and quick way I find is to use text to column.

    NOTE: you need to select your range before running this code and it works only on one column at a time.
    You can define your range within your sub if it is known, eg range(range("a1").range("a1").end(xldown)).select
    It is lightning quick though!