Formulas return 0 value

[Amy V.]

I am running into an issue I have never encountered in Excel before. I have a fairly extensive workbook with a lot of V-Lookups and referencing between the pages.

I put in a simple sum formula and it keeps returning 0.

I can highlight the cells and see a value in the bottom right but the cell still shows 0.

Has anyone else had this issue?

 

[tomas]

hm.. you might have set custom format, but if it's your workbook I doubt that . I haven't encountered it. the fastest way to solve would be the see a small sample of file.