Have you tried that, Domenic?
D2*10000 is 7.20117E16, so the TRUNC doesn't help.
--
David Biddulph

"Domenic" wrote in message
...
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!