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