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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/