Linked cell data showing 0's instead of an empty cell

[TAPS_MikeDion]

Hello all,
Is it possible to have the linked-to data in a sheet show an empty cell instead of a 0 when the linked-from data is just an empty cell?

I'm going to try to make this example as simple as possible. I even tried formatting the cells in both sheets as text, but it didn't help.

Ex: Using Excel for Mac ver. 16.40
Sheet 2 (linking sheet) has columns A - L, and may have either an X in a row's cell or else the cell will just be empty
Sheet 1 (linked-to sheet) has the same columns, but any cell that is empty in sheet 2 shows s aa 0 in sheet 1. I would like it to show empty cells, how it is in sheet 2.

FYI - In case it matters, there is conditional formatting running in sheet 1 just for color.

Thank you guys!

-Mike

 

[James006]

Hi,
There are several possibilities to Hide 0
see :

Display or hide zero values - Microsoft Support

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

support.microsoft.com

 

[TAPS_MikeDion]

Duh. I'm sorry, I didn't even think of that. It had been a long day. Thanks James!

 

[James006]

You are more than welcome