Julhs's advice is sound. Would most likely to be a cell formatting issue. If the formula works in a new workbook, check the cell's formatting in that workbook and then compare with the cell's formatting in your 'actual' workbook.

Hope this helps