You cant do it. The cell can contain only one value and
if that is a negative number you cannot have it display
a different number.

There are some options but why do you want it to keep the
negative number?

I can get it to show the date you want but it will be a positive
number and do other things to get it to be used as a negative
number if you reference it from other cells.


Chrissy.

"John Sheakley" wrote in message om...
Negative dates or times are displayed as ####. The cell retains the
negative value. How can I display negative time as "h:mm AM/PM" in red or
with a negative sign? The cell should retain the negative value.