Decimal value problem in a text box object?

[saumyashah90]

Hey i want to put two values after decimals.

For Example for 7945694.2234

I want 7945694.22 in my text box object.

I tried it using "Num Floor and Left"-->shows nothing after decimal

I also Tried It using "Subfield"-->shows nothing after decimal.

Even tried Num(),'#.##' or 0.00-->Gives 00 after decimal

[kaushiknsolanki]

Hi,

     Try this.

     =num(7945694.2234,'#,##0.00')

Regards,

Kaushik Solanki

[#3]

try this

num('7945694.2234' ,'#.00','.',',')

or simply write this

num('7945694.2234', .00,'.',',')

[sushil353]

use Round Function:

=Round(7945694.2234,0.01) will return 7945694.22

HTH

Sushil

[#5]

U can use...

=NUM(7945694.2234,'##.##')