How to not display the $.

  • Thread starter Thread starter lothario
  • Start date Start date
L

lothario

Hi,

I have the following 10 values in a column:
68.9

78.9
78.9
95.7
98
78
52.58

31.6

In formatting these currency cells, I use the Type $#,###.##
So the following values are displayed:

$68.90
$.
$78.90
$78.90
$95.70
$98.00
$78.00
$52.58
$.
$31.60

Can you please tell me how I should change the Type format
so that the $. does not display?

So if the value is blank or zero then the formatted Type
should just display a blank cell.


Thanks,
Luther
 
Can you not just use excel's currency format? It will show blank if there is
no number in a cell, the format it uses is $#,##0.00
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Lothario,

The formatting can be separated into 4 sections. The
first is for positive values; the second for negative
values; the third for zeros; the fourth for text. Each
section is divided by a semi-colon. The following format
worked for me:

#,##0.00_-;[Red](#,##0.00);;

The "_-" adds a gutter space at the end so positive and
negative values line up; "[Red]" change the font color of
negative values; The two ";;" indicate that zeros and
text should be blank.

Hope this helps...
 
No that does not work.

If the $#,###.## format Type is used then the resulting display
is:

$0.00
 
Thanks!
This worked for the most part.

The $ sign is missing from this format.

How can the $ sign be incorporated so that it appears before the amount
but not be printed if the amount is zero or cell has no value?
 
Back
Top