pls find the snapshot, getting value -9.0999987787-09 something I want -9.09
When I m converting it to Num((value),'0.00') it is giving me -0.00.
I assume you mean -9.0999987787E-09. This is 0.000000000909999. Multiply by 1E9 to get what you need.
=Num(value * 1E9, '0.00') - will give -9.10 which is normallt rounded
=Num(Ceil(value * 1E9, 0.01), '0.00') will give -9.09
Try like this
You are getting -0.00, because the actual number is -0.000000000909999, when you round of to two decimals you will 0.00
Hope this helps you.