I would like the cell numeric entry to appear in "( ###)" format (with
parenthesis)
ex:
(9) or (4.5)...

the entry MIGHT have decimals (ex: 4.5); however, for entries that are an
even integer (ex: 9) I want ONLY the WHOLE number without a THE DECIMAL
POINT to show
ex
(9) o.k.
(4.5) o.k.
(9.) not o.k. -note the decimal point

entering this format (###.##) forces a visible decimal point even with whole
numbers


thanks in advance,
mark