In Excel, if the formula refers to cell A1 and A1 is blank, the result is zero.

Try one of these:
=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)
or
=IF(ISNUMBER(Sheet1!A1),Sheet1!A1,"")
or
=IF(Sheet1!A10,Sheet1!A1,"")

Do any of those help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Howie" wrote:

I'm using a formula to copy a time from one cell to another
across sheets. The format of the time is h:mm AM/PM.

However, when the formula references an empty cell, it puts in a
default value of 12:00 AM and I need it to remain blank, (just as
the referenced cell)
It's such a simple copy formula. ie:

=sheet1!A1

I can't see anything causing this.
Has anyone any ideas?

thanks in advance,

Howard.

--
Howard Coakley
e-mail... howard<dot}coakleyatcoakley<dot].codotuk
Skype ID: howie10 (get skype from www.skype.com)