Hi,
I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there are symbols "-".
There is one cell that keeps displaying "0" no matter what I try to do. I have tried text to columns option, different cell formatting options but nothing works. I think that this might be related to the spreadsheet "2" or maybe the link (?) because if I paste the link to a cell that normally displays "-" it changes to "0" ??? However other links from the same workbook where is the spreadsheet "2" don't cause this problem !!!
Any suggestions will be much appreciated!
Cheers,
A
I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there are symbols "-".
There is one cell that keeps displaying "0" no matter what I try to do. I have tried text to columns option, different cell formatting options but nothing works. I think that this might be related to the spreadsheet "2" or maybe the link (?) because if I paste the link to a cell that normally displays "-" it changes to "0" ??? However other links from the same workbook where is the spreadsheet "2" don't cause this problem !!!
Any suggestions will be much appreciated!
Cheers,
A