How about =TRUNC(D22/1000000000000,4)*1000000000000
Enter it as =TRUNC(D22/1E12,4)*1E12
Or for the more general case
=TRUNC(D22/10^INT(LOG(D22)),4)*10^INT(LOG(D22))
best wishes
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Spring" wrote in message
...
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!