# 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

• 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 ) , 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.