The cell was formatted as Text when you entered the function.
Just re-formatting is not enough; format as number or General AND re-enter
the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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