Here is an excerpt of the data that I need to be transformed:
Current | What I need |
22.10399999999999 | 22.1040 |
22.1092.11 | 22.1092.11 |
22.1040.10 | 22.1040.10 |
22.2014999999998 | 22.2015 |
FH10202020 | FH10202020 |
022100210FSB | 022100210FSB |
I need to round the first set of decimals to 4 places. The data is currently in string format because I will lose the data with the letters, if I convert to double
Solved! Go to Solution.
Hey, sorry I also realized that in some instance there's data that is:
Current | What I need |
22.20230000000000000001 | 22.2023 |
Where now that would be rounded down, so I would just add "000" to the formula?
Perfect thank you so much!