>Hello,
>I am using a formula field to concatonate 2 decimal values separated by a dash. However, I want the result to trim all unneccesary trailing zeros and decimal points for both values.
>
>For example, I want values 10 and 8.5 to be "10 - 8.5". Now it shows "10.00 - 8.50".
>
>The formula I am using is CSTR({field1}) + " - " + CSTR({field2}).
>
>Any helpful hints?
Hi, Mike
Select File->Options.
Select the "Fields" tab
Click on "Number"
Select the "Number" tab
Click on "Customize"
From the "Decimals" drop-down select "1"
That should do it.
Regards,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!