none
Format to 2 decimal places?

    Question

  • Hi, i need to display my data in 2 decimal places but now i'm getting results after some calculation (for eg. 2.336224). How can i round it off to 2.34?
    Friday, May 25, 2007 8:15 AM

Answers

  • The most straightforward approach should be to just enter N2 in the format property of the textbox.

     

    Monday, July 28, 2008 3:38 PM

All replies

  • Hi,

     

    In the report designer, right click the cell where you want to display the above number then go to properties and then to the format tab and enter Format Code as "0.00". It should format the 2.336224 to 2.34.

     

    Hope it helps.

    Rajiv

    Friday, May 25, 2007 8:30 AM
  • hehe.. thanks so much! It's so helpful.. I came across this when i was exploring the program but didnt occur to me when i need it.. thanks!
    Friday, May 25, 2007 9:09 AM
  • You can't use "0.00" in .ToString(<format>) (dont ask me Smile) , insted enter that format in format property of textbox. It will do the trick.

    Saturday, July 26, 2008 8:43 AM
  • Hi,

    Right click on  required cell (or textbox) and select properties, in properties window click on Format tab and enter N in format code textbox.

    Monday, July 28, 2008 5:39 AM
  • hi

    my suggestion is not go for Format property. simply use the round function

     

    examples

     

    round(23.45645,2)

     

    this is the most persistance concept i had used ever.

     

     

    Monday, July 28, 2008 9:17 AM
  •  

    we can use

    =Format(Fields!Number.Value, "N")

    this is for 1,234.00 format

    OR

    =Format(Fields!Number.Value, "F")

    this is for 1234.00 format

    OR

    =Format(Fields!Number.Value, "0.00")

    this is for 1234.00 format
    Monday, July 28, 2008 12:23 PM
  • The most straightforward approach should be to just enter N2 in the format property of the textbox.

     

    Monday, July 28, 2008 3:38 PM
  • The only thing I could get to work was as an expression:
    =FormatNumber(Fields!DecimalColumn.Value,2)
    Thursday, January 14, 2010 4:38 PM
  • darkdusky,

    please elaborate further if you still need help on the issue. if your field is in float or decimal, and you need to show it in 2 decimal place, there are a lot of other format style you could use, depending on how you wants it. For example:
    =Format(Fields!DecimalColumn.Value,"N2")
    =Format(Fields!DecimalColumn.Value,"#,#0.00")
    =Format(Fields!DecimalColumn.Value,"C2")
    =Format(Fields!DecimalColumn.Value,"#.##")
    Chicagoan ...
    Thursday, January 14, 2010 4:44 PM
  • Iam not for sure if Decimal.Round works in C# or C++. I know it works in Visual Basic 2005 and 2008 in my own experience with it.

    Yes, it does work though.

     

    In C++ you can use setprecision(numberofdecimalplaces)

    Note the above in c++ is only for output not variables

    Monday, January 25, 2010 7:45 PM
  • I realize this thread is a bit old, but I have a closely related question. How do you get a number to round to two decimal places, only when there are decimals to begin with?

    In other words, I want 8.56789 to appear as 8.57

    ...but I also want 8 to appear as 8 (not as 8.00)

    thanks!


    Wednesday, August 22, 2012 10:49 PM
  • I also agree with Arun and Rajesh,

    When I need to specify the number of decimal points as part of an expression, e.g. ; - Tooltip series properties of a chart.

    I use; -

    =ROUND(Fields!Total.Value,2)

    or

    =FORMAT(Fields!Total.Value,"N")

    I hope this helps someone.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood

    Friday, November 09, 2012 1:17 PM
  • Just follow the next steps, you'll see that is very easy

    Julio Méndez

    Desarrollador de Sistemas de Información 

    Ecom Group

    Thursday, December 12, 2013 10:24 PM
  • Its works great. Thanks a lot
    Wednesday, July 23, 2014 10:56 AM