to number?

[Newbi1]

I have about 5 text fields the need to be converted to a number, modified and displayed. When I try to convert, I lost 90% of the number.

If the text was .677655576821 and it needs to be converted to a percent with 6 numbers after the decimal, it needs to change to this 67.765576%. Crystal keeps changinh it to .68 and will not let me use the rest of the numbers.

How do I find my way around in CR8.5?

 

[Turkbear]

Hi,
Use a formula to convert ( as you probably do) and format( Right-Click) the resultant number field to the desired # of Decimal places and be sure to set the Rounding to enough places..
@MyConvText
ToNumber('12.123234')

when formatted to allow 1.0000000 with rounding at .0000001

gives
12.123234 as the output.

( Tested in V10, but I believe the same formatting options are in 8.5)





To Paraphrase:"The Help you get is proportional to the Help you give.."