Posted to microsoft.public.excel.misc

Gator Girl Gator Girl is offline

external usenet poster

Posts: 36

ZERO VALUE NOT WORKING

The number format is 0.00. The font format is arial /bold /dark red.

The cell contains a rather complex formula (for me)
=IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="fl expart",0,AL6)))

I have been to tools/options/view and "unclicked" zero values. Still shows
0.00.

I tried a conditional format:
cell value equal to 0 / format font white

I can't get the darned 0.00 NOT to display no matter what I try.

HELP!!!

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
I did have this working but I want to know how	G Nisbet	Excel Discussion (Misc queries)	1	June 22nd 07 02:38 PM
IF not working	amandooshna	Excel Worksheet Functions	9	March 28th 07 02:11 PM
Add-ins not working	[email protected]	Links and Linking in Excel	2	March 20th 07 03:20 AM
SUM not working	scott	Excel Worksheet Functions	5	January 9th 07 05:18 PM
Why is this not working?	R.P.McMurphy	Excel Discussion (Misc queries)	6	August 30th 05 09:34 PM

All times are GMT +1. The time now is 03:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us