Select the cell and from the Edit menu use Clear All
Now re-enter the formula
Come back if this does not work, tell us the values in F42 and F44
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"aac" wrote in message
...
i have a formula in a cell =F42-F44, it should be a $ value that shows up,
but nothing is showing up, it's just blank, not even a zero.