Formating an empty cell to not result in "0".

[Jeff Rich]

I'm wanting Sheet1 to ready information from Sheet2. If certain cells on Sheet2 have no data, the corresponding Sheet1 cell enters it as "0".
Is there a way for this cell leave blank rather than "0"?

In merged cells with text entered to form a paragraph statement. Is there a way to equally justify the text within the boundaries of the merged cells?

[BadlySpelledBuoy]

Try custom formatting the cells as 0;;"" and see if that works for you.

BSB

[Pete_UK]

Is the data that you are returning through your formula a text value or numeric? If a text value, then you can add &"" at the appropriate place in your formula (I can't see your formula, so I can't say exactly where it should go).

Hope this helps.

Pete

[Jeff Rich]

Buyer Letter Tab
Architectural Plans: Cell D28 ='Estimating Sheet'!F143, whereas ('Estimating Sheet'!F143) either is a Y or Blank. If there is no information in that Cell (Blank) I want Architectural Plans: Cell D28 to be blank rather than "0".

[Pete_UK]

Okay, change the formula to this in D28:

='Estimating Sheet'!F143&""

That will ensure that if the cell is blank then a blank will be returned.

Hope this helps.

Pete

[Jeff Rich]

AWESOME!! It worked.

Thanks Pete.

[Pete_UK]

Glad to hear it, Jeff, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete