Hi!

You don't need the parenths in that formula:

=Sheet1!A1

You could use this to return a formula blank:

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

OR, use this custom format to suppress the display of 0's:

0;-0;;@

OR, goto ToolsOptionsViewZero Values

Uncheck Zero Values

NB: if the real cell value of Sheet1A1 is 0 then you probably wouldn't want
to use the custom format or the Tools......option!

Biff

"menphee" wrote in message
...
i know this must be simple.....but......im referencing one sheet to
another....example on sheet 2 =(sheet1!a1) ...i want the cell to be blank
on
sheet 2 unless there is information on sheet 1......i know this isn't
brain
surgery...but ive tried all the cell formats and nothing seems to return a
blank on sheet 2....HELP
Thanx, Mike