formatting the difference between two cells
 

I have two cells with two different numbers and I am trying to have Excel
format the difference between the cells.

formatting the difference between two cells
 

What do you mean by format the difference? Please elaborate.
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Hollywood003" wrote:

I have two cells with two different numbers and I am trying to have Excel
format the difference between the cells.

formatting the difference between two cells
 

In Excel the symbol for minus is the minus sign (-), so the difference
between A1 and B1 is =B1-A1.
If you want only the magnitude of the difference, use =ABS(B1-A1)
--
David Biddulph

"Hollywood003" wrote in message
...
I have two cells with two different numbers and I am trying to have Excel
format the difference between the cells.