Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
=num(7945694.2234,'#,##0.00')
Regards,
Kaushik Solanki
try this
num('7945694.2234' ,'#.00','.',',')
or simply write this
num('7945694.2234', .00,'.',',')
use Round Function:
=Round(7945694.2234,0.01) will return 7945694.22
HTH
Sushil
U can use...
=NUM(7945694.2234,'##.##')