Re: Zero values displaying as "-"

Round it to 0 decimal places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Uncle Ben" <reel_jemm_spamnot@xxxxxxxx> wrote in message
news:uuhT49aAGHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
> Here is the formatting I'm currently using:
>
> _(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
>
> This allows me to display all zero amount cells as "-" instead of 0's.
>
> The problem I have is for cells that contains small negative balances
under
> .50 - those cells do not format to "-" but to (0). So the report looks
> silly, with -'s on all zero+'s and (0) on all zero-'s.
>
> Is there a cure for this grand malaise? TIA.
>
>


.

Relevant Pages

  • Re: very hard deleting rows issue
    ... Your sentiments are well meant: ... >>> HTH ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: summing comma separated values in a range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ... >> number of csv to the number in the formula. ...
    (microsoft.public.excel.programming)
  • Re: SUMIF where values to be summed are formula
    ... >> HTH ... >> (remove nothere from the email address if mailing direct) ... >>> criteria to be considered in deciding which values are to be added. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Last Saved Date and Time
    ... Did you put the code in ThisWorkbook code module as stated in original ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Find last occurance of text in range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
Loading