Hello,
I need VBA code to make the number of decimal places in cell A1 to be one more than that in cell A2 when it has been divided by 1000.

For example, in cell A2, then number will be 2.4 (0.0024 after being divided)

Cell A1 would normally 5682.33 but given the above would be 5682.325654.

Any help much appreciated.