Art of BI: C# Convert Decimal to String

By | In Art of BI | July 13th, 2009

Microsoft usually has good documentation but on this particular topic I always felt that it was lacking. Here is the MS core documentation for converting a decimal to a string, http://msdn.microsoft.com/en-us/library/59095yyw.aspx.

I recently needed to ensure that I was only getting only two decimal places on a dollar amount as I converted it into a string and was going to write a nice lengthy post myself and then I found this really nice post over at csharp-examples (view post).

Mainly I was looking for the following syntax just to ensure that I was setting up things correctly:
[sourcecode language=’csharp’]
// just two decimal places
String.Format(“{0:0.00}”, 123.4567); // “123.46”
String.Format(“{0:0.00}”, 123.4); // “123.40”
String.Format(“{0:0.00}”, 123.0); // “123.00”
[/sourcecode]

They have some other great custom formatting items as well. Check ’em out.

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).