how can i on opening a macro replace all the 1's in column k with reformatting as text and then 0001. The number of 1's can very from 25 lines to 2000 lines. Its a csv file and currently on opening its changing the cells from text to general.
URGENT assistance is required. thankyou all
URGENT assistance is required. thankyou all