how do I get a formula to not show the amount but still be there
I need to have a formula entered but I do not want the zero to show
|
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" wrote in message ... I need to have a formula entered but I do not want the zero to show |
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 -- Ruthki ------------------------------------------------------------------------ Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503 View this thread: http://www.excelforum.com/showthread...hreadid=467856 |
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com