Format Function

[Rob T]

I'm looking for a way with either Format, FormatNumber or FormatCurrency to
show a dollar amount the normal way (like 123.40). But if the value is 0, I
want it to return "". I would like to avoid using an IF statement or
calling a costum function to do this.

(I have some reports that would be clogged with a bunch of 0's and it could
be distracting for the user to read through)

Is it possible?

Thanks. -Rob T.

 

[Ivan Belov]

Hi Rob,

How about

Console.Write ("{0:c}",amount);

?

/Ivan Belov/

 

[Patrice]

See :
http://msdn.microsoft.com/library/d...uide/html/cpconcustomnumericformatstrings.asp
(Custom formatting strings)


Patrice

 

[Rob T]

Thanks. I was hoping to do it within the format function...but this will
work fine.