Linked Cell Zero Value

N

Nick

I have two Excel files with linked cells.
When I enter data in file one, save and close it. I then
open the file two. In the linked cells that have a null
value in file one now show as a zero value in this second
file.

Can anyone tell me how to format the cells of file two so
they have a null value, as the cells they are linked to in
file one?

Regards
Nick
 
M

Max

One way for a cleaner look is to
suppress zero values from showing in the sheet via:

Tools > Options > View tab > Uncheck "Zero values" > OK
 
N

Nick

To easy

Thanks very muck
Nick
-----Original Message-----
One way for a cleaner look is to
suppress zero values from showing in the sheet via:

Tools > Options > View tab > Uncheck "Zero values" > OK
Click to expand...
 
Top