Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to convert the following amount into two decimal correct number format ?
suppose I have number as 153,050.00 (something like 1,53,050.00)
Regards,
mahamed
If(FieldName < 1000, Num(FieldName,'#,##0.00'),Num(FieldName,'#,##,##0.00')) as FieldName
Hey thanx buddy.
It works...!