Are the cells really empty?

Maybe they have spaces in them?

When you hover over the error-checking arrows do you get a message?

What happens when you clear those cells?


Gord

On Wed, 4 Apr 2012 15:17:35 +0000, Dorian74
wrote:


Hi All,

I am trying to have a spreadsheet where i check the delivery time on
orders (attached a picture).
Essentially, it calculates the difference between the "Promised Date
(A1)" and the "Atual Date (A2)" i.e. A1-A2
The problem is where is have blank cells with no information yet. then i
get the nice error message "#VALUE!"

Can anyone help in having these cells show nothing instead of the error
message?

Thank you!


+-------------------------------------------------------------------+
|Filename: PO Date.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=318|
+-------------------------------------------------------------------+