Loading

Rounding Large Dollar amounts

Thomas

I want to round a double value to the nearest $100,000 (i.e. $3,456,789 = $3.500,000)

However this needs to be done as a string because it is a label for an open source Chart drawing tool that takes a string to create the labels.

Any suggestions?

2 Replies

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

Vulpes14y ago
Accepted answer
This code should do it:

string s = "$3,456,789";
string t = s.Substring(1).Replace(",", "");
double d = double.Parse(t);
d = Math.Round(d/100000) * 100000;
t = d.ToString("C0"); // $3,500,000
Thomas14y ago
I didn't think of dividing and then multiplying... that is great. (and actually stripping out the commas isn't needed because it is originally a double but I was using the ToString("C") to display it as currency.)

Thanks for the quick answer.