View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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?