P Paul B Sep 15, 2005 #2 monkee, here is one way, =IF(A1="","",A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
monkee, here is one way, =IF(A1="","",A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
R Ruthki Sep 15, 2005 #3 Other ways 1..set worksheet to not show zero values by selecting from menu Tools, options, view tab, deselect zero values. 2. set a conditional format to turn font colour to same colour as background where the cell value is between certain values (eg between -0.5 and 0.5) ruthki
Other ways 1..set worksheet to not show zero values by selecting from menu Tools, options, view tab, deselect zero values. 2. set a conditional format to turn font colour to same colour as background where the cell value is between certain values (eg between -0.5 and 0.5) ruthki
