$ sign formats

[utahbiker7]

How to you remove the dollar "$ - " formats from each cell that doesn't
have a value entered? If there is no value in the cell, I want the format
"$ -" to not show otherwise they will print on my forms all these $ signs.
I remember in Lotus that it was easy to tell the spreadsheet to ignore the
format if no value was entered. I can not figure out how to do this in
Excel.

Any help would be greatly appreciated.

Thanks

 

[Rick Rothstein \(MVP - VB\)]

How is the $ sign being inserted now? If you cells just contain numbers and
if you then Format Cells as currency, the $ sign will not show up on blank
cells automatically. Also, what is that - (dash, minus sign) there for?

Rick

 

[Bernard Liengme]

A cell with value 0 formatting as accounting will display: $ -
You could delete the cell ( a blank does not show anything)
You could use Custom format:
Accounting is _-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-
It is the third item _-$* "-"??_-; that is the format for zero
So use _-$* #,##0.00_-;-$* #,##0.00_-;" ";_-@_-

best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[utahbiker7]

Rick,
I'm using a pre-made template that is used each day. The spread sheet is
designed with several columns and breaks for each vendor. I enter the data
each day for the vendors and then print out to the forms. The vendor may
have 10 line items for one day where as maybe only 1 or 2 line items entered
the next day. Because the template has all 10 lines formated, I must erase
(I put a tick mark in the non-value fields) the remaining lines so the $ sign
(on my screen it shows and prints "$ -" for the cells with no amounts
entered) doesn't show. When I used Lotus, all I had to do was check a field
do not show format if no value was entered. In Excel I don't see this
option. I was wondering if there was a way to turn the formats off for the
cells that do not have dollar values entered? This is my question.

 

[utahbiker7]

Thanks Bernard - that is exactly what I was looking for.

_($* #,##0.00_);" "(* (#,##0.00);_(* " "_);_(@_)

This format took away $ signs in the fields I didn't have a value.

This will save me time entering and make the print outs more professional
looking too.

A+ help!