Formula returns "0"; How do I make it return nothing?

try

=IF('sheet1!A1'=0,"" , 'sheet1!A1')

regards

You could also use a custom format of General;General;

and then just use

='sheet1!A1'

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jonlandrum" <jonlandrum.26hclm_1145397300.7637@excelforum-nospam.com> wrote
in message news:jonlandrum.26hclm_1145397300.7637@excelforum-nospam.com...
>
> tony, it worked beautifully. Thank you very much! I don't know why I
> didn't post that question here six months ago. I've just been coloring
> the zeros white. :o)
>
> Now I have to find another excuse for spending all day with these
> files.
>
> ~Jonathan
>
>
> --
> jonlandrum
>
> http://jonlandrum.com/about/
> ------------------------------------------------------------------------
> jonlandrum's Profile:
http://www.excelforum.com/member.php...o&userid=33615
> View this thread: http://www.excelforum.com/showthread...hreadid=533945
>

You can still use the technique

Assuming you never get negative dates

dd/mmm/yyyy;;

But with currency

£#,##0.00;-£#,##0.00;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jonlandrum" <jonlandrum.26hgrm_1145402701.1982@excelforum-nospam.com> wrote
in message news:jonlandrum.26hgrm_1145402701.1982@excelforum-nospam.com...
>
> Bob, I didn't think of that, either. However, it wouldn't work because
> the formating has to be either in date format or dollar format.
>
>
> --
> jonlandrum
>
> http://jonlandrum.com/about/
> ------------------------------------------------------------------------
> jonlandrum's Profile:
http://www.excelforum.com/member.php...o&userid=33615
> View this thread: http://www.excelforum.com/showthread...hreadid=533945
>