Dollar Sign conditional display

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nine - 08 Jul 2006 03:10 GMT

I am creating an invoice and would like the Dollar Sign to not be displayed
in a column when the row is blank, and to be displayed when there is data in
the row. Is this possible?

Thanks
Dave

Reply to this Message

Gord Dibben - 08 Jul 2006 03:30 GMT

If the cell is truly blank no currency sign will show.

I assume you have a formula like =A1*B1 in the cells but no data in the
reference cells.

Perhaps a trap....

=IF(OR(A1="",B1=""),"",A1*B1)

Gord Dibben MS Excel MVP

>I am creating an invoice and would like the Dollar Sign to not be displayed
>in a column when the row is blank, and to be displayed when there is data in
>the row. Is this possible?
>
>Thanks
>Dave

Reply to this Message

nine - 08 Jul 2006 04:05 GMT

Thanks for the help
Dave

> If the cell is truly blank no currency sign will show.
>
[quoted text clipped - 15 lines]
>>Thanks
>>Dave

Reply to this Message

JON JON - 08 Jul 2006 10:25 GMT

Alternatively:

with the cells selected

1) Goto Format>Cells
2) Choose the "number" tab
3) On category list choose "Custom"
4) on the "type" box write $#,##0_);($#,##0);""

You can also use 0 instead of "" depending on what you want

> Thanks for the help
> Dave
[quoted text clipped - 18 lines]
>>>Thanks
>>>Dave

Reply to this Message