How to do number formatting in mvc3 view

like below fixes the issue You can't do this with one custom format.
What you can do is make a macro that does the input for you and modifies each cell format as it puts the value into it. You can use the Macro Recorder to get a handle on where to start with this.

With these it helps How can I format the following and specify the number of decimal places in an mvc3/asp.net/webgrid? , You can format decimal values in C# as so:

String.Format("{0:0.00}", 123.4567);      // "123.46"
String.Format("{0:0.00}", 123.4);         // "123.40"
String.Format("{0:0.00}", 123.0);         // "123.00"

grid.Column("Val", format: @<text>@String.Format("{0:0.00}", (decimal)(100/3)) </text>)

it fixes the issue I am trying to take a 10 digit phone number (1234567890) that is returned from the database and format it to render on the view page as (123) 546-7890. , you could use the substring function:

'(' + substr(first three digits) + ')' + substr(middle three digits) + '-' + substr(last four)

To fix this issue Here's a code snippet from a getValueAsString() method from an ExtendedViewColumnConverter class that handles number formatting based on the user locale.
The code assumes that the variable currentLocale contains the user locale. currentLocale is an instance of java.util.Locale.Locale and I assume that you have logik that handles this e.g. as part of a user bean. If not, then one way of getting the current locale is to do this:

Locale currentLocale = FacesContext.getCurrentInstance().getViewRoot().getLocale();

public static class ExtendedViewColumnConverter extends ViewColumnConverter {

    ...

    @Override
    public String getValueAsString(final FacesContext context, final UIComponent component, final Object value) {

        if (value instanceof Number) {
            NumberFormat nf = NumberFormat.getInstance(currentLocale);
            DecimalFormat df = (DecimalFormat) nf;
            df.setRoundingMode(RoundingMode.HALF_UP);
            switch (this.colDef.getNumberFmt()) {
            case ViewColumn.FMT_GENERAL: {
                // no further formatting needed
                break;
            }
            case ViewColumn.FMT_FIXED: {
                df.setMinimumFractionDigits(this.colDef.getNumberDigits());
                df.setMaximumFractionDigits(this.colDef.getNumberDigits());
                break;
            }
            default: {
                // no further formatting needed
                break;
            }
            }
            return df.format(value);
        }
    }

    ...

}