Select all the cells and just use the formula as if you were only applying
to the first. Excel will adjust them all.

--
HTH

Bob

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

wrote in message
...
Thanks Mike,
Now how do I apply that formula to a whole rang of cells within that
column.
Sorry if these are simple questions, but I didn't seem to get any
sense from the built in help!

Neill