Cells showing up with 0 when blank

shreked12

Rules violation
Joined
Mar 14, 2019
Messages
17
I have a workbook with cells linked via copy and paste link.

Thing is when cells are blank the corresponding cells that linked to they are showing as "0". Is there anyway I can stop this happening.
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

sunrise06

Active Member
Joined
Oct 27, 2006
Messages
254
Change to a formula such as - =IF(Sheet1!A1="","",Sheet1!A1). This will return a blank if cell copying from is blank.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,667
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top