I am trying to write a Macro as i have a lot of data, but due to the format it doesn't pick it up as a number only as text, so i have to click into the cell and press enter to turn it into a number.
So i have data in column K and want to say if K2 contains data, click into the cell and press enter, then move onto cell K3 and repeat until reaching a cell which contains no data.
I am trying to do this as i am trying to apply a formula to these cells, but currently it says 0 instead of the correct answer.
(i have tried highlighting all and changing from general to currency but it didn't work).
If there is an easier way to change the data types please suggest away, just think a macro will work
So i have data in column K and want to say if K2 contains data, click into the cell and press enter, then move onto cell K3 and repeat until reaching a cell which contains no data.
I am trying to do this as i am trying to apply a formula to these cells, but currently it says 0 instead of the correct answer.
(i have tried highlighting all and changing from general to currency but it didn't work).
If there is an easier way to change the data types please suggest away, just think a macro will work