• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula shows a 0

S

Shazz

Member
I am hoping someone can help, I am using the = Formula to show the same text as in another sheet in Excel, the only problem is if there is no text in the original sheet, on the sheet I am using the = Formula it is showing a 0, can anyone advise how I can get rid of the 0 as it is addresses and I do not want this within the address.

Your help is appreciated.

Shazz xx
 
Hi Shazz,

If you want your formula to not show the Zeros, use the custom cell format:
General;-General;;@

Regards,
 
Hi Khalid,

I am using the General format, but when I use the = Formula on sheet two it is showing a 0 in all the cells that there is no text in sheet 1?

Shazz
 
Thanks for that, that worked a treat.

One problem, when I mail merge the Addresses into word, it is still showing the 0.

Any ideas??

Shazz
x
 
Because it still has zero as value stored in the cell.

In that case, use formula below to pull data from another sheet.
=IF(ISBLANK(Sheet2!B2),"",Sheet2!B2)
 
You must log in or register to reply here.
Back
Top