Hi List, Using excel 2003, I have a couple of cells that say "number value has formula" can anyone tell me how to get the cell to display the amount it's supposed to display? This only happened when I formatted the cells to display in currency and it's only a couple of cells that are affected, the rest of the cells display ok. Hope someone can help. Jim