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/

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" wrote in message
...
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/

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...

-----Original Message-----
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/

.

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?



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

No that does not work.

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

$0.00



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