Hi,

How can I disable the display of "####" in a cell whenever a formula has
errors?
I am using formula's to populate the sheet2 depending on the values entered
by user in sheet1, Initially there is no data in sheet1 but as formula's are
present in sheet2, so I am getting this notification for error in formula in
sheet2.
I simply want to disbale this notification and want the cell's in sheet2
appear normal without any notification and also without getting filled with
"####"

Kindly help,

Thanks ,
Sandeep