Linking excel sheets and getting 0's all over

Closed
Michellllah - Jun 14, 2011 at 04:51 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2011 at 05:07 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 14, 2011 at 05:07 PM
Well one way would be to use if

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