Hi
Can anyone help in how I can write VBA code to simulate the convert text to numbers function when Excel gives you that error/drop-down option to change the cell value to a number?