I have to interpret data for scientific reports. We report the data all in the same units, however, the lab sends the data in different units.
I would like to know how to make a macro that you can apply to a selection of cells or columns to convert the result (divide the number by 1000).
The tricky part of this is that the numbers are often presented as ">5" in which case I would need the macro to change it to ">0.005".
As my data will often comprise upwards of 50 columns, it really needs to be a macro so that I could highlight a column and click the macro. It would then replace the contents of the cells with the revised figures.