marvin

Junior Member

Posts: 6

Making a 0 invisible with a formiula

I have put a formula in in a worksheet and wish to make the 0 invisible when it comes up. The worksheet is already in the don't display mode. I tried the make the 0 white and that did not work . the formula that I am using =if(B8<=149,"1","0") can anybody help.

Thank You

Last edited by marvin : September 18th 09 at 11:58 PM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
text is invisible	learningaccess	Excel Discussion (Misc queries)	2	September 23rd 08 09:57 PM
Invisible sheets	emilh	Excel Worksheet Functions	2	May 20th 08 02:30 PM
Invisible Spreadsheet	CCripe	Excel Discussion (Misc queries)	2	December 15th 07 08:35 PM
Making Border of Frozen Panes Invisible	Carl	Excel Discussion (Misc queries)	4	December 20th 06 02:22 PM
Invisible bar on bar chart	KK	New Users to Excel	3	November 24th 06 01:22 PM

All times are GMT +1. The time now is 10:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us