How to display values only upto 2 decimal places

Question

I have a table column "Amount" of type money. When I am retrieving its value through a store procedure, it returns the value upto 4 decimal places(because of type money). I want the value upto two decimal places and I want it to handle in the code. How will I do it by rounding off the value to 2 decimal place. Thanks

Can have a look at the answer in the below link.. http://stackoverflow.com/a/37997363/4619541 — Md. Shafiqur Rahman, Jun 23 '16 at 16:50

p.s.w.g · Answer 1 · 2019-03-14T17:04:58.687

24

Read Custom Numeric Formats for detailed instructions on formatting numbers.

value.ToString("0.00");

In C# 6 or later, you can use string interpolation for a somewhat cleaner syntax.

$"{value:0.00}";

edited Mar 14 '19 at 17:04

answered Mar 08 '13 at 06:36

p.s.w.g

146,324
30
291
331

5

+1. This one is better if you always want 2 decimal places even if value has only 1 say. This should be the accepted answer. – Mitch Wheat Mar 08 '13 at 06:40

score 5 · Accepted Answer · answered Mar 08 '13 at 12:40

Well, I tried it and got the correct result.

Below is the code that I used:

funding.amount= Math.Round(decimal.Parse(dr["Amount"].ToString()), 2).ToString();

//since the amount was of string type, therefore I used the above code. we can also use the below code:

decimal.Round(yourValue, 2, MidpointRounding.AwayFromZero);

http://msdn.microsoft.com/en-us/library/9s0xa85y.aspx

score 4 · Answer 3 · answered Mar 08 '13 at 06:36

4

Format in presentation layer:

string.Format("{0:#.##}", value);

answered Mar 08 '13 at 06:36

Mitch Wheat

295,962
43
465
541

score 2 · Answer 4 · answered Oct 22 '18 at 07:18

2

string.Format("{0:0.00}", your_value);

answered Oct 22 '18 at 07:18

Nitin Dhapte

21
1

2

While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value. Also the comment by @Md. Shafiqur Rahman links to the same solution – Hintham Oct 22 '18 at 07:23

score 1 · Answer 5 · answered Mar 08 '13 at 06:45

1

You can use Standard Numeric Format Example:

decimal dValue = 1.268;
string sValue = dValue.ToString("N"); // 1.27

answered Mar 08 '13 at 06:45

whastupduck

1,156
11
25

score 1 · Answer 6 · answered Mar 08 '13 at 07:17

1

In Leave Event write this code

 Double x;
        Double.TryParse(txtLocl.Text, out x);
        txtLocl.Text = x.ToString("0.00");

After leaving it allowed only two decimal places

answered Mar 08 '13 at 07:17

sree aneev

141
4
5
18

score 0 · Answer 7 · answered Jan 01 '20 at 11:52

0

test this code:

value.ToString("F2");

answered Jan 01 '20 at 11:52

Meysam Ghorbani

55
4

score 0 · Answer 8 · answered Dec 03 '20 at 06:41

0

Text='<%#Bind("Value","{0:F2}") %>'

answered Dec 03 '20 at 06:41

Code

679
5
9

How to display values only upto 2 decimal places

8 Answers8

Linked