I need a formula that can change all my numbers to 2 decimal places. My data includes numbers in millimetres and inches and varies between 0 decimal places to 3 decimal places.
Also some cell values are a range that is represented like this:
0.5 ~ 0.645mm
Not sure if the ~ symbol affects this or not.
Cheers,
Jayden
Also some cell values are a range that is represented like this:
0.5 ~ 0.645mm
Not sure if the ~ symbol affects this or not.
Cheers,
Jayden