Greetings.

Ok so my problem is that I get a "Currency" formatted value from the database and this value sometimes comes as a whole number (without decimals) and sometimes it doesn't.

But, when I output the information as "string" into an XML File, I always need to show the 2 decimal places even if they are zero.

I tried with the following code:

price = string.Format("{0:N2", decimalPrice);

This works if e.g: the variable decimalPrice has a value of 59.33
However if it has a value of 59 this will not work, and will throw a format exception.

Any suggestions?

Thanks,

CB

Solved it with

price = string.Format("{0:0.00}", decimalPrice);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.