ExcelBanter - exponential into text or number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - exponential into text or number (https://www.excelbanter.com/excel-discussion-misc-queries/151983-exponential-into-text-number.html)

santhosh

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?

Bob I

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?

All times are GMT +1. The time now is 05:46 AM.