Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scientific Notation
- Thread starter EdwinGene
- Start date
to numeric and one that will convert it back again?
synapsevampire
Programmer
There is a UFL, search for notation:
-k
-k
- Thread starter
- #3
Unfortunately, the function ScNotn is only half-useful. It requires that any positive number being converted to scientific notation (I have not tried negative numbers) be 1.0 or greater. This means it will not convert a number like .03 to scientific notation. In order for ScNotn to accept it you have to multiply it by 100, meaning it is not the same number and you get a result of 3E+000 when what you really want is 3E-002.
- Status
Similar threads
- Locked
- Question
- Locked
- Question