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.
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.