Scientific notation

[George]

If I have a numeric field and enter the value of 1.0E4 how can I format the field so that it shows 10000?

[CraigH]

No warranty expressed or implied, but this may work:

Define a field "sciNum" as text and

a field "plainNum" as a calculation field returning a number.

plainNum =

TextToNum( Left(sciNum, ( Position(sciNum,"E", 1, 1) - 1 ) ) ) *

10 ^ ( TextToNum( Right(sciNum, Length(sciNum) - Position(sciNum,"E", 1, 1) ) ))

[CraigH]

More explanation:

You will enter your number in scientific notation as text into the field "sciNum" , but display the results of the calculation field "plainNum".

The first line of the calculation finds the stuff to the left of the "E" character and then multiplies it by the 10 raised to the power of th stuff on the right side of the "E".

[fkrebs]

Thanx Craig, George was asking on my behalf since i didn't know about this great site.

f

------------------

[This message has been edited by fkrebs (edited March 18, 2001).]