H HP Feb 2, 2004 #1 How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021
B Bas Cost Budde Feb 2, 2004 #2 HP said: How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... 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()
HP said: How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... 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 Feb 2, 2004 #3 How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... ? format(1.3901E7, "0") but, as Bas points out, they are not quite the same numbers. HTH Tim F
How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... ? format(1.3901E7, "0") but, as Bas points out, they are not quite the same numbers. HTH Tim F
D Dirk Goldgar Feb 3, 2004 #4 HP said: How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... You could use the Eval() function. For example, in the Immediate Window: ?Eval("1.3901e+007") 13901000
HP said: How can I convert to text field 1.3901e+007 to either a number or text representation of 13901021 Click to expand... You could use the Eval() function. For example, in the Immediate Window: ?Eval("1.3901e+007") 13901000
H hp Feb 3, 2004 #5 Odd the 1.3901e+007 came from an Excel file (via an import), which was represted as 13901021.
B Bas Cost Budde Feb 3, 2004 #6 hp said: Odd the 1.3901e+007 came from an Excel file (via an import), which was represted as 13901021. Click to expand... Has to do with column width. That is exactly why I usually don't entrust my data to Excel.
hp said: Odd the 1.3901e+007 came from an Excel file (via an import), which was represted as 13901021. Click to expand... Has to do with column width. That is exactly why I usually don't entrust my data to Excel.
