General information
Category:
Coding, syntax & commands
Title:
Keeping last 4 digits?
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...:>)
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