 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Scientific 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! Try... =TRUNC(D22*10000)/10000 Hope this helps! > How do I truncate a number in scientific notation without rounding the last > number? [quoted text clipped - 4 lines] > I have tried =TRUNC(D22,4) with no success. I am fairly new at excel so > very detailed responses are welcome. Thank you! Have you tried that, Domenic? D2*10000 is 7.20117E16, so the TRUNC doesn't help.  SignatureDavid Biddulph > Try... > [quoted text clipped - 11 lines] >> I have tried =TRUNC(D22,4) with no success. I am fairly new at excel so >> very detailed responses are welcome. Thank you! My mistake, I misunderstood... > Have you tried that, Domenic? > D2*10000 is 7.20117E16, so the TRUNC doesn't help. 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 > How do I truncate a number in scientific notation without rounding the > last [quoted text clipped - 5 lines] > I have tried =TRUNC(D22,4) with no success. I am fairly new at excel so > very detailed responses are welcome. Thank you! 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. SignatureKind regards, Niek Otten Microsoft MVP - Excel | How do I truncate a number in scientific notation without rounding the last | number? [quoted text clipped - 4 lines] | I have tried =TRUNC(D22,4) with no success. I am fairly new at excel so | very detailed responses are welcome. Thank you!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.