Most efficient way to convert text to values

  • I have a column of roughly 10000 numbers, that are currently formatted as general so I can’t do any mathematical stuff with them.

    I want to create a macro that would make these proper values and was wondering what the best way would be.

    I tried recording multiplying each cell by one but that doesn’t work.
    Ive now found out that adding a new column in and using the VALUE function works.

    I was was just wondering if there is a more efficient way? Maybe adding all the data to an array?? Have no clue with arrays.

    Any advice?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!