Thanks Bob - I came up with the same thing after I had enough coffee and
could think clearly......Thanks for your help!

Randy

"Bob Phillips" wrote:

Seems too obvious, but

=b1-a1

and format as

#,##0.00;-#,##0.00

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Randy" wrote in message
...
I'm trying to show the opening for the day in one column the closing in
the
next column and then the number Up/Down in the next column and have it
represented as a negative (down) or positive (up) for the day.

Thanks,
Randy