Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scientific Notation Truncation
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scientific Notation Truncation
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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scientific Notation Truncation
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! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scientific Notation Truncation
My mistake, I misunderstood...
In article , "David Biddulph" <groups [at] biddulph.org.uk wrote: Have you tried that, Domenic? D2*10000 is 7.20117E16, so the TRUNC doesn't help. -- David Biddulph |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scientific Notation Truncation
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 "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scientific notation of CSV | Excel Discussion (Misc queries) | |||
Scientific notation | Excel Worksheet Functions | |||
how can I turn off scientific notation | Excel Discussion (Misc queries) | |||
scientific notation | Excel Discussion (Misc queries) | |||
Scientific notation | Excel Discussion (Misc queries) |