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?