Scientific Notation Truncation
Try...
=TRUNC(D22*10000)/10000
Hope this helps!
In article ,
Spring wrote:
How do I truncate a number in scientific notation without rounding the last
number?
example:
D22: 7.20117 E12 and I want 7.2011(0) E12
I have tried =TRUNC(D22,4) with no success. I am fairly new at excel so
very detailed responses are welcome. Thank you!
|