Thank you Mike and peo.
i meant to type formula not format.
Thanks
again

"Mike H" wrote:

Bobby,

The correct formula is

=c3-b3

you don't need the Sum bit.

Enter you formula on the topmost cell and select that cell and all the cells
you want to fill then:-

Edit|Fill|Down

If you already have data in columns C & B then enter the formula in the
topmost cell and doubleclick the fill handle


Mike



"bobby02169" wrote:

Hi All,
I am trying to do a mileage worksheet, where I am putting in the staring
mileage in column B and the ending in column C with the total milage driven
in column D
This is what I would like to do D=C-B.
I can do it by formatting the cell in each row in column D =SUM(C3-B3), Can
i format column D so the formula is automatically entered for each row?
Thank you in advance
bobby