View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don't want $0.00 to show on invoice Don't want $0.00 to show on invoice is offline
external usenet poster
 
Posts: 1
Default I don't want dollar sign with zeros in unfilled currenty field?

I am creating an invoice (not using a template). I don't want the unused
currency fields to display zeros / dollar sign. $0.00.

How do I leave the unused currency fields blank so that the $0.00 is not
showing until a dollar amount is entered in a given line?

Thanks, Connie