Format Function

  • Thread starter Thread starter Rob T
  • Start date Start date
R

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.
 
Back
Top