How to convert one decimal place numbers to two decimal place c#

Jayanta Mukherjee

Hi,

I have a weird situation here. I've got some data in excel format like below (sample):

ITEM	QUANTITY	RATE/UNIT
ABC	2	97.8
ASD	13	125.2
ZXC	1	294
QWE	5	35.7
POI	7	201
LKJ	30	177.1
MNB	25	208.1
XYZ	18	123.3

Also, I've been given the sumtotal value i.e. the total after (QUANTITY x RATE/UNIT) of each item which in this case is 16431.02. But if I do a sumproduct on excel on the given data it gives 16437.60 which is due to the data of column RATE/UNIT being rounded to either 0 or 1 place after decimal place (.) and pasted as value so I cannot know what the two decimal value of the cell should be.

I'm trying to convert the data of column RATE/UNIT to numbers with two decimal places using the available data mentioned above using c#.

Can anybody help me on this ?

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
you can also round the end result
var Total=Math.Round((Decimal.Parse(columns[3])*column[2]),2);
Jayanta Mukherjee4y ago
You're all getting it wrong. In the source excel file the RATE/UNIT column data doesn't have the value after one decimal place, so using Math.Round wouldn't do the job it will simply convert 97.8 to 97.80 and so on. Please check the expected values I mentioned in my 1st reply.
Jignesh Kumar4y ago
Hi,

Please refer this thread,
https://www.c-sharpcorner.com/UploadFile/9b86d4/how-to-round-a-decimal-value-to-2-decimal-places-in-C-Sharp/
Vikas Panwar4y ago
1. double d = 100.5;
2. string dc = d.ToString("0.00");
3. Response.Write(dc.ToString());

Rijwan Ansari4y ago

use Math.Round(value,int)

Example:

Math.Round(123.3444,2) // output 123.34

Math.Round(122.1,2) //output 122.10

Sachin Singh4y ago

so, what?

You need to apply the same whilereading CSV (Excel)

string path = "path of your csv file ex:- D://yourcsv.csv";
string[] lines = System.IO.File.ReadAllLines(path);
foreach(string line in lines)
{
var columns = line.Split(',').ToList();
var formttedArray= columns.select(x=> new{
Item= columns[0],
Qty=columns[1],
RatePerUnit=Math.Round(Decimal.Parse(columns[3]),2);
})
foreach (string column in formttedArray) {
// Do something
}
}

Srinivasan Ramamoorthi4y ago

Use decimal.parse(text value)

Srinivasan Ramamoorthi4y ago

Retrieve the rate/unit text value and convert into decimal with 2 precision point.

Jayanta Mukherjee4y ago

Hi Sachin, I need to round every item of RATE/UNIT so that when I multiply them by their respective counterpart of QUANTITY column and sum them then the result is 16431.02. The desired result in this case should be as below:

RATE/UNIT
97.75
125.22
293.50
35.67
200.05
177.09
208.12
123.32

Hope you now understand what I'm trying to do

Sachin Singh4y ago

you can use

Math.Round(val, 2)

var roundValue=Math.Round(Rate/Unit, 2);