Excel :Reading Exponentials

[R_Win]

Hi I am having a numeric variable(accno) having 20 digits but when i am importing it in to sas it was showing exponentials how can i Resolve this.
I have converted the variables in to Charrater by adding a character variable .But the (account no) is not getting correctly

Ex: 19867839765432678098 out:1.90E98

Pl let me know

[Patrick]

Import the account number with informat $20.

Never store an account number in a numeric variable.

You can't store 20 digits in a numeric SAS variable with full precision - and you sure don't want to change account numbers when rounding happens 😉

HTH
Patrick