H
HP
How can I convert to text field
1.3901e+007
to either a number or text representation of
13901021
1.3901e+007
to either a number or text representation of
13901021
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bas Cost Budde
HP said: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()
T
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
D
Dirk Goldgar
HP said: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
H
hp
Odd the 1.3901e+007 came from an Excel file (via an
import), which was represted as 13901021.
import), which was represted as 13901021.
B
Bas Cost Budde
hp said: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.