Excel 2007 : copying text with = and getting 0

[Shadow Wizard]

I am trying to automatically change the content of one cell to match another cells text value using =A14 (for example) and, when A14 is empty, the destination cell displays 0. How do I make the cell containing the formula, the destination cell, display a blank cell, if the original (A14) is blank?

Thus, if the content of A14 is "Hello" and the formula in B14 is "=A14" B14 displays "Hello" However, when the content of A14 is empty, B14 displays 0. When A14 is empty, I also wish B14 to be empty.

[ConneXionLost]

Try this in your B14 cell:

=IF(A14="","",A14)

[Driven1]

Try this in your B14 cell:

=IF(A14="","",A14)

This code given above works for me so this should solve your question? Good luck.

[arthurbr]

You could also keep the =A14 formula and under Tools - Options - View Tab uncheck "zero values"

This might of course have unwanted effects elsewhere