If both the formula bar and the cell display the formula rather than the
result, then the cell was formatted to Text before the formula was entered.
Clear the cell and re-enter the formula
--
Gary''s Student - gsnu200903


"cmc4" wrote:

The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.