correct the expression of the textbox field
-
hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. how the word length is there that much it should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)... i've tried by removing some of the #'s but it is for fixed number.. please help me...
-
hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. how the word length is there that much it should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)... i've tried by removing some of the #'s but it is for fixed number.. please help me...
It is customary to group 3 digits at a time. To achieve that you simply need to use
"#,##0.00"as your number format - the result will contain as many ',' characters as necessary e.g.Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89 -
It is customary to group 3 digits at a time. To achieve that you simply need to use
"#,##0.00"as your number format - the result will contain as many ',' characters as necessary e.g.Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89