Scientific Notation Truncation

[Spring]

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!

 

[Domenic]

Try...

=TRUNC(D22*10000)/10000

Hope this helps!

 

[Bernard Liengme]

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

 

[David Biddulph]

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

 

[Domenic]

My mistake, I misunderstood...

 

[Niek Otten]

If you really have 7.20117 E12 in a cell in Excel, then it must be text. So apart from text manipulation you can't do this.
Even text manipulation followed by conversion to number would not get you any further than 7.2E12, because of Excel's maximum
precision of 15 decimal digits.
To be fair, it's not an Excel limitation, it's a limitation of the IEEE floating point standard.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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!