-I'm using non english Ms Excel 2010
I have made one sheet with original table like this:
I need just data, formatting doesn't matter. Like this:
1, I know about excel options > advanced card > Show a zero in cells that have zero value.
2, I know about custom formatting exact cells with text: 0;-0;;@
3, I know about Pivot table zero setting, but I haven't pivot tables and never will use.
so those ones, are not solutions for me.
Because I need to keep blank cells blank in 'copy' sheet same as in original, and cells with value zero, same with value zero. But now excel made all zeros out of purpose by changing untouched cells to zeros and also zero value cells to zero. I need make him distinguish between those two types of zero cells, or just simply not write zeros into blank cells.
I have found this old article:
Please help me how may I set it well
Thanks a lot