What type of error gives you ##### in a cell?

Only one I can think of is a negative date or time

Maybe =IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Mon, 16 Jun 2008 21:13:00 -0700, Sandeep Singh
wrote:

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