Hi,
here is what I trying to do,
example I have sheet 1 with data, I have formula in X1 which read the value in A1.
I copy the data from sheet 1, X1 to Sheet 2 A 1(Paste Value only)
Sheet 2 I have VLOOKUP formula and doesn't work because the value I post in A1
When I click A1 cells, it show little !mark, if I click the option convert to number my vlookup function work.
I like to have macro which convert all of the data to number.
here is what I trying to do,
example I have sheet 1 with data, I have formula in X1 which read the value in A1.
I copy the data from sheet 1, X1 to Sheet 2 A 1(Paste Value only)
Sheet 2 I have VLOOKUP formula and doesn't work because the value I post in A1
When I click A1 cells, it show little !mark, if I click the option convert to number my vlookup function work.
I like to have macro which convert all of the data to number.