Convert Scientific Notation

[HP]

How can I convert to text field

1.3901e+007

to either a number or text representation of

13901021

 

[Bas Cost Budde]

How can I convert to text field

1.3901e+007

to either a number or text representation of

13901021

You cannot convert 1.3901e+7 into 13901021 since there is more
information in the latter value.

I believe the other way around is handled by Val()

 

[Tim Ferguson]

How can I convert to text field

1.3901e+007

to either a number or text representation of

13901021

? format(1.3901E7, "0")

but, as Bas points out, they are not quite the same numbers.

HTH

Tim F

 

[Dirk Goldgar]

How can I convert to text field

1.3901e+007

to either a number or text representation of

13901021

You could use the Eval() function. For example, in the Immediate
Window:

?Eval("1.3901e+007")
13901000

 

[hp]

Odd the 1.3901e+007 came from an Excel file (via an
import), which was represted as 13901021.

 

[Bas Cost Budde]

Odd the 1.3901e+007 came from an Excel file (via an
import), which was represted as 13901021.

Has to do with column width. That is exactly why I usually don't entrust
my data to Excel.