help on formatiing NUMBER to TEXT

[Samji]

Hi all,

Using WTX 8.2,
Input 123.00 output 123
Type is defined as Number, presentation: Decimal, Format ####.##

Input is text, so when I use TEXTTONUMBER function the nonsignificant zero's after decimal get trauncated.
I want output as 123.00.

I tried using TONUMBER function..
=TONUMBER(field1,"{####.##}") but still i get 123

Can any one suggest how to acheive this.

Thanks in advance.

 

[eyetry]

Type is defined as Number, presentation: Decimal, Format ####.##

Also set 'Places', 'Decimal Min and Max' as well as 'Whole# Min and Max'

 

[Samji]

thx eyetry.
If I set the places then it is working..in mercator 5.0 version this was not required. Is it a limitation in wtx.

 

[eyetry]

May have been a 6.0 change. It allows you to be more specific with your settings but if you aren't aware of it....