| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exponential into text or number
The column contain the number "20070126127100072" when we select the column
and press F2 and enter the number chaned to "2.00701E+16". How can I retrive the original value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
exponential into text or number
Type in in again, but this time as text. Anything past 15 digits is not
maintained as number. santhosh wrote: The column contain the number "20070126127100072" when we select the column and press F2 and enter the number chaned to "2.00701E+16". How can I retrive the original value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| X-axis exponential n^1.85 | Charts and Charting in Excel | |||
| X-axis exponential n^1.85 | Charts and Charting in Excel | |||
| change scientific notation (exponential) back to text | Excel Discussion (Misc queries) | |||
| Bi-Exponential Fit | Excel Discussion (Misc queries) | |||
| saving exponential to text data | Setting up and Configuration of Excel | |||
Linear Mode
