on 11-19-2023 6:31 PM
Hello Experts,
Ive a requirement to convert floating point values eg: 4.7799999999999997E+01 to a numeric value.
The result should be: 47.79 (two digits after the dot and not rounded)
Or 9.400000000000000E+00 to 9.40
Ive checked several posts but didnt get the result I wanted.
Can you please advice how to achieve this?
Thank you in advance,
Kind regards,
Did you try FormatNum from Arithmetic functions? You should use #.00 format for your requirement.
However the 4.7799999999999997E+01 will be 47.80 and not 47.79 because of rouding.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
11 | |
10 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.