I tried formatting the cells as general before and after I entered the
formula but I kept seeing the formula in the cell not the result.
I eventually added a new sheet and it worked ok.But I still wanted to know
what happened