General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
>I have a series of numbers with up to 9 significant digits after the decimal point and would like to truncate the character values down to 4 significant digits.
>
>For example I have the following two values:
>
>123.456789012
>98.765432109
>
>I want to return these values:
>
>123.4567
>98.7654
>
>I can write a function to use something like ATC() to find the decimal point but is there a better way? Sergey, you will no doubt have something interesting and insightful so thanks in advance...:>)
IANS but how about ROUND(lnX, 4)?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only