Linking excel sheets and getting 0's all over

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a document that we adjust the master, and then each fiscal year I want on separate sheets but to be updated with the master. I linked the separate sheets to the master already, but if there was a blank cell in the master it left the other sheets with 0's in the cell. With the 0's it messes up the flow, is there a way for this not to happen without using conditional formating to turn the font white??

Thanks!
Michell

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Well one way would be to use if

=IF(A1="". "", A1)